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?

"Bob Phillips" wrote:

=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)

"Mac1" wrote in message
...
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!


"Ceptor55" wrote:

What formula are you using specifically??

"Mac1" wrote:

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.