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.
Last edited by ruggedcashew; 01-27-2012 at 02:33 PM.
Hi,
you could try INDIRECT
=SUMIF(INDIRECT("C2:J2"), ">=" &B2,INDIRECT("C3:F3"))
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon below the post.
Please, mark your thread [SOLVED] if you received your answer.
Forum rules: http://www.excelforum.com/forum-rule...rum-rules.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks