Give us an example of what range you first used AutoSum on then show us what
you want to add to the range.

i.e. where do you add the "more cells with numbers"

Are you inserting these above the autosum formula?

In that case the new numbers should be included.

One more thing............is calculation mode set to automatic?


Gord Dibben MS Excel MVP

On Mon, 27 Oct 2008 11:45:01 -0700, CC wrote:

I know this should be easy, but....
If I autosum several cells...and then want to add more cells with numbers
and get a new autosum of all cells - how do I do this? When trying, it's not
adding them all up - it is just coping the total of the last cell. Can you
help?