excluding from autosum

**goldenchook** · 09-25-2010, 07:44 PM

I would like to know how in autosum to exclude an entry from the calculation without removing it from the column ?
Thanks

**mdbdesign** · 09-25-2010, 08:21 PM

Simplest:just subtract =SUM(D2:D23)-D12

**goldenchook** · 09-26-2010, 06:09 AM

Thanks, that's great.
Are there any other ways of doing it?
I am trying to ascertain whether an error was infact an error or intentional.
Thanks

**martindwilson** · 09-26-2010, 06:12 AM

a bit more explanation would be handy!

**goldenchook** · 09-26-2010, 06:27 AM

I'll try to be a bit more specific, well kind of.
Someone has a shopping list, next to it the cost with the running total autosumed at the bottom.
The bread for $1.60 is listed, but somehow, the autosum total is total minus the $1.60?
Can this in someway be a program error, or does it need to be manually done ?

And yes in response to private message, you did know well.

**teylyn** · 09-26-2010, 06:28 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!