Hello All
New member here.
I've been struggling trying to get a formula to work for me so I thought I would turn to you pros for some help. My novice/Intermediate skills seem to be tapped out at this point.
In the attached file you will see that I am trying to get a SUMIF formula to change sum ranges based on a column header ie. =SUMIF(Sheet2!$A$2:$A$15,Sheet1!$A2,Change based on Sheet1 column header). Ideally I would be able to copy the formulas in the week end date columns to each other without having to manually change the sumif range column each time I get to a new fiscal month/quarter/year.
The example I have attached is rough but is a snipit of the big picture. Sheet1 is a summary sheet that shows hours by resource code by week end date, fiscal month, fiscal quarter, and fiscal year. With Sheet2 being the raw data table. As you can see Sheet2 has multiple repeated resource codes thus the summary of each resource code on Sheet1.
I apologize if my above question is not clear so please let me know if more detail is needed for you to help.
Thank you very much in advance.Sumif Example.xlsx
Bookmarks