Sum question

[thescream80]

Hello,

i have a easy question. Atleast I hope it is easy. I am trying to count every cell in column b that has text in it or is not blank. Either one will work I think.

Thank you so much for any help!!

 

[Asala42]

Normally I'd use either

=COUNTA(B:B)

or if B contains formulas

=SUMPRODUCT(--(LEN(B:B)>0))

 

[joeu2004]

=SUMPRODUCT(--(LEN(B:B)>0))

Never ever use B:B with SUMPRODUCT or any array parameter. It creates arrays of 1M+ elements in Excel 2007 and late.

COUNTA(B:B) is questionable. It depends on how clever the COUNTA function is. Hopefully, it determines the last row used and only counts that subrange (less than 1M+ rows).

 

[Robby19]

Why not just;

=COUNTIF(B:B,"*")