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.