Sums & Deleting Columns

D

Duncs

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
 
B

Bob Phillips

=SUM(INDIRECT("H4:K4"))


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Top