Log In
Register
Home
July 11, 2017
Offline
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
Trusted Members
Moderators
November 1, 2018
Offline
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.
July 11, 2017
Offline
Many thanks for your help
Regards
Paul
July 11, 2017
Offline
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
1 Guest(s)
