View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Living the Dream Living the Dream is offline
external usenet poster
 
Posts: 151
Default 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.