Sums & Deleting Columns

[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

 

[Bob Phillips]

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


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Duncs]

Cheers Bob

Duncs

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


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)