Counting Cells (including Empty Ones)

[Guest]

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!

 

[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!

 

[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

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!

 

[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.

 

[DDM]

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

 

[Dave Peterson]

Or just:

=ROWS(A5:A90)

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

 

[RagDyer]

Or just

=ROWS(5:90)
--


Regards,

RD