Counting non blanks different from ""

[vsoler]

My range contains cells, say B11:B50 with formulas; some of them
return numbers, some others text and still some others nulls (blanks
or "").

I want to count the number of non blank cells in the range, but the
formula =COUNTA(B11:B50) always returns 40 because "" are not
considered blanks.

Is there any alternative formula that I can use for my purpose?

Thank you

 

[Mike H]

Maybe

=SUMPRODUCT(--(B11:B51<>""))

Mike

 

[Peo Sjoblom]

=SUMPRODUCT(--(A1:A10<>""))


--


Regards,


Peo Sjoblom

 

[Ashish Mathur]

Hi,

You can also use this formula.

COUNTA(range)-COUNTBLANK(range)

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Mike H]

Tested?

Hi,

You can also use this formula.

COUNTA(range)-COUNTBLANK(range)

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com