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