Counting Non Blank Cells

  • Thread starter Thread starter Lindsey
  • Start date Start date
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!!!
 
Sorry, but I want to count the numbers in column B if the cell in column A is
not blank.
 
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))
 
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
 
Back
Top