COUNTA - ADDING CELLS

  • Thread starter Thread starter Mac1
  • Start date Start date
M

Mac1

I've figured out how to use CountA to add up the non-blank cells in a column.
It works fine when I insert a cell anywhere in the middle of the cells I am
already counting, but not if I insert it at the very top or very bottom.

Is there any way to make the formula extend itself to allow for this?

Thanks.
 
I currently have:

=COUNTA(D8:D28)

When I add cells in the middle it expands itself to become D8:D29 etc but
that's the best I can do!
 
=COUNTA($D$8:OFFSET($D$8,,,COUNTA($D:$D)-COUNTA($D$1:$D$7),1))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thank you,

This seems to give me the total number of filled cells in the whole column,
except cells D1-D7. Is there a way to make it give me only the total number
of cells between D8 and D28, but also allowing me to insert the cells at the
top or bottom?
 
I am sure I can if you can tell me how we know that say D29 is an inserted
cell, not one that had data originally. In other words, how do we know where
you want to stop counting?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top