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.

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.

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.

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

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.

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)

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