=SUM(OFFSET(B1,2,0,7,1))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"T De Villiers"
wrote in message
news:T.De.Villiers.29sqqz_1150967707.2076@excelfor um-nospam.com...

In B1 I have a formula: sum(B3:B9),
if i now insert a row in B3 the formula changes to sum(B4:B10),
how do I keep the formula as sum(B3:B9) when inserting the line.

Thanks


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile:
http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=554452