Counting Non Blank Cells

[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!!!

 

[Sheeloo]

Try
=COUNTA(A1:A15)

adjust A1:A15 to your range...

 

[Lindsey]

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

 

[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))

 

[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