• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sum Function
#1
Hi All,

please check excel sheet  one series in column "A" i want sum only number of "1" in column "B".


regards
PC


Attached Files
.xlsx   Querry sheet.xlsx (Size: 8.12 KB / Downloads: 16)
  Reply
#2
Please elaborate the question
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Reply
#3
(26-Nov-2019, 12:22 PM)pushpendarchaudhary Wrote: Hi pushpendarchaudhary,


i Am unable understand  you question 
  Reply
#4
I have enter a series in column "A" i have used of Alt + enter in column , i wanna sum only numeric digit one in column "B".
  Reply
#5
=LEN(A2)-LEN(SUBSTITUTE(A2,"1",""))
  Reply


Forum Jump:


Users browsing this topic: 1 Guest(s)