I am looking to add a sumif formula that has the ability to dynamically adjust the "sum range" as my source data shifts colums. The issue that I am having is that my summary page will have multiple full years layed out but my source data is adjusting the months populated as the year progresses. In my example, I have source data 8-11, however, next month when updated month 12 will come into the source data (represented in column F greyed out). I need my summary sumif formula to automaticall move the sum_range to column F for the actual sums and likewise I need the "estimate" sum range for month 10 to move to column G.
I was thinking of some sort of offset/index/hlookup on named columns but not wure what that would look like.
Let me know you thoughts.
Regards.
Bookmarks