Hi,

One way:

=SUM(INDIRECT("E"&ROW(A2)&":V"&ROW(A2)))

HTH
Jean-Guy

"PowerPoint Jedi" wrote:

Morning,
I currrently have a spreadsheet with the following formula =sum($E2:$V2)

I insert a column and shift all columns from E-V to the right (makeing them
F-W). I would like the formula to remain =sum($E2:$V2) but it keeps chagning
to =sum($F2:$W2). Is there anyway to make a cell reference stay put no
matter what or will it always move when you insert columns inside the range?