Quickly count used rows?
Hi Rob
Assuming your cell Range Is A2 to I61 then
If the range is populated with Alhpa characters, then
=COUNTIF($A$2:$I$61,"""")
If the rnage is populated with Numeric, then
=COUNTIF(A2:I61, "0")
or, if there is a mix of Alpha-Numerics
=COUNTA($A$2:$I$61,"""")
HTH
Mick.
|