Sums & Deleting Columns
I have a spreadsheet that totals figures on horizontal rows. However,
some of the columns are deleted on a weekly basis. Th emain problem I have with this is the sum calculations...everytime a column is deleted, the sum calculation decreases by one column. I need the calculation to remain static. e.g. my sum says =SUM(H4:K4) If I delete column H, this formula changes to =SUM(H4:J4), when I need it to stay at =SUM(H4:K4) I've tried absolute cell references etc, but I can't get it to work. Anyone any ideas? TIA Duncs |
Sums & Deleting Columns
=SUM(INDIRECT("H4:K4"))
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Duncs" wrote in message oups.com... I have a spreadsheet that totals figures on horizontal rows. However, some of the columns are deleted on a weekly basis. Th emain problem I have with this is the sum calculations...everytime a column is deleted, the sum calculation decreases by one column. I need the calculation to remain static. e.g. my sum says =SUM(H4:K4) If I delete column H, this formula changes to =SUM(H4:J4), when I need it to stay at =SUM(H4:K4) I've tried absolute cell references etc, but I can't get it to work. Anyone any ideas? TIA Duncs |
Sums & Deleting Columns
Cheers Bob
Duncs Bob Phillips wrote: =SUM(INDIRECT("H4:K4")) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Duncs" wrote in message oups.com... I have a spreadsheet that totals figures on horizontal rows. However, some of the columns are deleted on a weekly basis. Th emain problem I have with this is the sum calculations...everytime a column is deleted, the sum calculation decreases by one column. I need the calculation to remain static. e.g. my sum says =SUM(H4:K4) If I delete column H, this formula changes to =SUM(H4:J4), when I need it to stay at =SUM(H4:K4) I've tried absolute cell references etc, but I can't get it to work. Anyone any ideas? TIA Duncs |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com