YasserKhalil
08-06-2010, 12:02 PM
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..
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..