Hi There,
I am creating a report that takes either the sum or average of each 4 week period in a year, as you can see from the attached on the Report page are the figs by week and on sheet2 is the report showing as 4 week blocks, however, I am having to do this manually using a sum or average formula. Is there an Index/match formula I can use that looks up the site and the 5 elements and sums or averages the 4 week period?
Thanks
Paul
Are the sites always in the same order as in your example?
I'd suggest using a couple of helper columns and a helper row to avoid repeated looking up of the same information - see attached version of your workbook. You can hide row 1 and cols A:B if desired.
Many thanks for your help
Regards
Paul
Hi Velouria,
Sorry, but just realized that the sites are not always in the same order as in my example, Going forward I will be adding/removing sites so need a more dynamic formula if possable?
Thanks
Paul
The formula in the workbook I posted doesn't actually require them to be in the same order.
