Forum Discussion
Solved
How to calculate the average of a group starting from the data of the individual people
Hi everyone, On "Sheet 1" I have a ranking of values relating to people (from highest to lowest) deriving from a formula: on one column I have the name and on the adjacent column the value. Lin...
=AVERAGE(FILTER($B$1:$B$20,IFNA(XMATCH($A$1:$A$20,E2:E10),0)))
If you have access to FILTER and XMATCH you can use this formula. The formula is in cell E12 and filled to the right in this example. Of course you can place the groups and averages in another sheet. Only for illustration i use one worksheet.
=AVERAGE(FILTER($B$1:$B$20,IFNA(XMATCH($A$1:$A$20,E2:E10),0)))
If you have access to FILTER and XMATCH you can use this formula. The formula is in cell E12 and filled to the right in this example. Of course you can place the groups and averages in another sheet. Only for illustration i use one worksheet.
- I thought there was an easier way, but that's exactly what I needed. Thank you very much!
One dumb thing I think I did, is that I disposed all the names on a column with the belonging group repeatedly on the side (2 vertical columns).
It's better to do like you did: putting groups as horizontal labels and the names under them.
