counta not working

[methody]

Hello there
I have range of cells in column A. some are filled with non numeric value. some have formulas which sometime have "". The formulas are of the type =IF(Z10=2, "", B3)

I want to count the number of non empty cells. counta does not seem to work as it does not treat the formulas which are giving "" as empty.

Can anyone help please

 

[syntaxed]

You could modify your formula to =ROWS(range)-COUNTBLANK(range) or =COUNTA(range)-COUNTBLANK(range)

 

[Sandeep Warrier]

Or

=SUMPRODUCT(--(LEN(Range)>0))

 

[Aladin Akyurek]

Hello there
I have range of cells in column A. some are filled with non numeric value. some have formulas which sometime have "". The formulas are of the type =IF(Z10=2, "", B3)

I want to count the number of non empty cells. counta does not seem to work as it does not treat the formulas which are giving "" as empty.

Can anyone help please

If the range consists of text values and you want to do a count of non-blank cells (that is, excluding "")...

=COUNTIF(A2:A100,"?*")

If there are also numbers to count in:

=COUNT(A2:A100)+COUNTIF(A2:A100,"?*")