Future in Hands club     Office Productivity     Microsoft Office     Microsoft Excel     Microsoft Excel Stuffs     Ask Excel Question    Others Sum Function
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sum Function
pushpendarchaudhary
Lots of things to do

Fresher
Joined: Nov 2017
Posts: 2

Reputation: 0
#1
26-Nov-2019, 12:22 PM
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)
  Find
  Reply
Vivekananda Sinha
The next innovation

Mentor
Joined: Apr 2017
Posts: 590

Reputation: 0

Location: Delhi
#2
26-Nov-2019, 10:53 PM
Please elaborate the question
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Website   Find
  Reply
Chetan@FIH
Lots of things to do

Fresher
Joined: Nov 2019
Posts: 4

Reputation: 0
#3
27-Nov-2019, 04:32 PM
(26-Nov-2019, 12:22 PM)pushpendarchaudhary Wrote: Hi pushpendarchaudhary,


i Am unable understand  you question 
  Find
  Reply
pushpendarchaudhary
Lots of things to do

Fresher
Joined: Nov 2017
Posts: 2

Reputation: 0
#4
27-Nov-2019, 06:10 PM
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".
  Find
  Reply
Sajan
Lots of things to do

Fresher
Joined: Sep 2018
Posts: 1

Reputation: 0
#5
25-Nov-2021, 01:10 PM
=LEN(A2)-LEN(SUBSTITUTE(A2,"1",""))
  Find
  Reply


Forum Jump:


Users browsing this topic: 1 Guest(s)