Totalling Collumns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stormingerman - 19 Dec 2005 01:31 GMT

I work on Bids and Proposals and use the AUTOSUM key to total columns. But
when I then edit the bid by adding/inserting an additional item, sometimes
Excel adds the addtional amount to 'Total', sometimes it doesn't. Has
resulted in some embarrassing situations. What am I doing wrong?

Signature

Rolf

Reply to this Message

Max - 19 Dec 2005 01:45 GMT

Leave an empty row between the totals row and the items to sum above, e.g.:
In A11: =SUM(A1:A10), where A10 will be the empty row. Then if we insert
new rows by selecting this empty row, the SUM() will always auto-adjust to
include the entire range above.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

> I work on Bids and Proposals and use the AUTOSUM key to total columns. But
> when I then edit the bid by adding/inserting an additional item, sometimes
> Excel adds the addtional amount to 'Total', sometimes it doesn't. Has
> resulted in some embarrassing situations. What am I doing wrong?
> --
> Rolf

Reply to this Message