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.