View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vsoler vsoler is offline
external usenet poster
 
Posts: 79
Default 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