Nel post news:T.De.Villiers.29sqqz_1150967707.2076@excelfor um-nospam.com
*T De Villiers* ha scritto:

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


Hi,

try this way:

=SUM(INDIRECT("B3:B9"))

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy