cell reference to stay fixed

Hello forum

question please. I've got a spreadsheet, part of which attached

b9, is the sum of D6 to D9,
b14, is the sum of D10 to D14

now each row is actually the length of seconds of something

every so often, the D column will be updated, and the column will be shifted to the right (the D column is actually this weeks update, the E column is last months update)
so there will be a new D column, and 'D' column will be moved to 'E', 'E' will become 'F' and so on

usually, if I insert a new 'D' column, the b9 reference will then change to E6 to E9?

is there any way of making it so that the b9 will always reference D6 to D9, so that it won't change to E6 to E9, when I insert the new column?

s_xl.png

Originally Posted by 6StringJazzer

Here is one way (there are probably others):

Formula:

Please Login or Register  to view this content.

thanks- and thanks for the other suggestions too