Counting Non Blank Cells

L

Lindsey

I have a long list of names in column A, with blank cells every so often. In
column B, there are list of numbers.

Cake 8
Cookies 4
3
Cake 5
9
Cookies 2

I want to count if the cell in column A is not blank. Please let me know if
you have any other questions, thanks!!!
 
L

Lindsey

Sorry, but I want to count the numbers in column B if the cell in column A is
not blank.
 
S

Sheeloo

COUNT would be same...

You can also use to count when both A and B are not blank
=SUMPRODUCT(--(A1:A15<>""),--(B1:B15<>""))

To Sum col B when A is not blank use
=SUMPRODUCT(--(A1:A15<>""),(B1:B15))
 
F

Francis

try this

assuming that you have data in A2 to A10, the first row being the headers
=SUMIF(A2:A10,"<>""",B2:B10)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top