0
I have a data set that looks something like this. At the moment, data is sorted by region, and at the end of each section there is a row for Region averages for all the months.
However, I'd like to analyse the data and produce pivot tables and charts and I'd like to make the dataset more robust. I was thinking of introducing a new column for Region averages, as per my screenshot below. Is this a better way of representing the averages or should I look into using a separate spreadsheet for these?
Many thanks in advance
sonic99
Posted 2019-09-09T09:41:25.183
Reputation: 51
Assuming left-up corner of shown data is A1:
D8=SUMIF($B$3:$B$7,$C8,D$3:D$7)/COUNTIF($B$3:$B$7,$C8)– Akina – 2019-09-09T09:54:47.210