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



"Lindsey" wrote:

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

"Sheeloo" wrote:

Try
=COUNTA(A1:A15)

adjust A1:A15 to your range...

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Lindsey" wrote:

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