Google-sheets – Take data from a specific row

google sheets

I'm making a form where people can enter in certain dimensional grades for a specific name. So each row of the spreadsheet will probably read something like:

Name | Strength | Agility | Luck 
John |     8    |     7   |   1

…etc. But John and his peers may be graded many times, so their names will continue to appear down the spreadsheet. I'd like a way to take specific peoples' grades and enter the averages of their dimensions somewhere else in the spreadsheet (or a different spreadsheet). Is there a way for me to do that?

Best Answer

Use AVERAGEIF :

=AVERAGEIF(B4:B6,B10,C4:C6)

B4:B6 - column Name C4:C6 - column Strength (for exmpl.) B10 - specific name

This function is available only in New Google SpreadSheet: https://support.google.com/drive/answer/3256529

Related Topic