Solved: Count cells except empty cells

[YasserKhalil]

Hi guys
I have a range with formulas and sometimes they return blank
At the end I want to count this range with the formula


=Counta(A1:A20)
But the problem is that it counts the empty cells as they have formulas
I want to count excluding these empty cells..

[Bob Phillips]

Try

=COUNTA(A1:A20)-COUNTIF(A1:A20,"")

[YasserKhalil]

Always Perfect Mr. xld
Thank you very much