I have a table with dates in Row 1 and headings in Column A. Column B contains the formula =SUMIF(C2:J2, ">=" &B2,C3:F3) which calculates the total of columns C3:F3. Every day I insert a new Column C. By doing this the formulas in Column B changes to =SUMIF(D2:J2, ">=" &B2,D3:F3). I don't want the formula to change as the new data doesn't get calculated.
I've seen a post which mentions Index and Indirect but I couldn't see how/where I would use these functions.
thank you in advance
P.S.
Minutes after posting I think I figured it out.
I just have to put =SUMIF(Indirect("C2:J2"),">="& B2, Indirect("C3:F3"))
This looks like it's working.
Bookmarks