absolute cell reference

[justme]

in column C I have a formula which is the sum of column D to column AA.
=IF(SUM($D5:zz5)<>0,SUM($D5:zz5),"")

Problem: Every day I insert a column next to column C, which becomes the new column D and my formula changes to =IF(SUM($E5:AAA5)<>0,SUM($E5:AAA5),"")

How can I keep the cell reference $D in the formula?

 

[MrKowz]

I want the formula to give me the sum of row 3, from column D forward on the sheet labeled Sales. The formula will reside in in the sheet now called Sheet1.

Try:

=SUM(INDEX(Sales!3:3,,4):Sales!AA3)

 

[justme]

MrKowz - I was so close! Thank you!!

 

[MrKowz]

MrKowz - I was so close! Thank you!!

No problem, thanks for the feedback.