|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
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
|