Hi everyone,
I'd be grateful if someone could lend their expertise on a sum if + vlook up formula. I have a report with weeks, 1-52, for multiple years listed vertically, with some data in an adjacent column. I'd like to create a formula to sum certain rows based on the periods the weeks relate to (for example, weeks 1-4 relate to period 1, so i'd want to only sum the rows for weeks 1-4)
Sure, i can do a simple sum if formula, however to span weeks covering a number of years, it would involve quite a bit of manual manipulation to change the sum if statements to relate to the required period. I'd quite like to use a formula that i can roll down the weeks over the 4x years worth of weeks data i have.
I was thinking i'd need a separate look up table to show what weeks belong to what period (i.e. wk1-4 = period 1), but can't quite get it to work
Any help appreciated!
Motley
Bookmarks