Counting Cells (including Empty Ones)

J

Jacob

Is there a way i can count teh number of cells between A5:A89 including the emply cells? I would like it to stay up-to-date automatically without my having to go back and do all the math myself. So if i add a few rows in between i will automatically count the new rows. It does that if there are numbers there but not if there are NO numbers. Thanks!
 
J

Jim Rech

Maybe the ROWS function.

--
Jim Rech
Excel MVP
| Is there a way i can count teh number of cells between A5:A89 including
the emply cells? I would like it to stay up-to-date automatically without
my having to go back and do all the math myself. So if i add a few rows in
between i will automatically count the new rows. It does that if there are
numbers there but not if there are NO numbers. Thanks!
 
D

DDM

Jacob, the right way (?), the wrong way (?), and DDM's way:

=COUNTA(A5:OFFSET(A89,0,0,-1))+COUNTBLANK(A5:OFFSET(A89,0,0,-1))

--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com


Jacob said:
Is there a way i can count teh number of cells between A5:A89 including
Click to expand...
the emply cells? I would like it to stay up-to-date automatically without
my having to go back and do all the math myself. So if i add a few rows in
between i will automatically count the new rows. It does that if there are
numbers there but not if there are NO numbers. Thanks!
 
D

Dave Peterson

Just a warning.

=countA() and =countblank() aren't always mutually exclusive.

if you have a formulas that evalute to ="", then you'll see problem.
 
D

DDM

Let's go back to Jim Rech's original suggestion and do it this way then:
=ROW(A90)-ROW(A5)
 
Top