Counting non blanks different from ""
 

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

Counting non blanks different from ""
 

Maybe

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

Mike

"vsoler" wrote:

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

Counting non blanks different from ""
 

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


--


Regards,


Peo Sjoblom

"vsoler" wrote in message
...
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

Counting non blanks different from ""
 

Hi,

You can also use this formula.

COUNTA(range)-COUNTBLANK(range)

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"vsoler" wrote in message
...
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

Counting non blanks different from ""
 

Tested?

"Ashish Mathur" wrote:

Hi,

You can also use this formula.

COUNTA(range)-COUNTBLANK(range)

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"vsoler" wrote in message
...
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