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