CountA formula counting blank cells with formula

[vikramisrani]

Hi,

I am using CountA to count the cells yielding a value.

These cell have a formula that leaves the cell "blank" if a criteria is not met.

However, ContA is also counting the cells with no value, but just a formula (yielding blank as result).

Any suggestion on this issue will be a great help.

Please suggest.

 

[Arithos]

Another solution that avoids the array formula is:

=COUNT(A:A)+COUNTIF(A:A,"?*")

There are often many ways to skin a cat!

Indeed it is, thats why its so cool, Different solutions to all problems! I just happen to love SUMPRODUCT =P And avoid Array formulas when I can.