Hi! Sorry if this was already asked. I know it’s very basic, but I’m not able to solve it and didn’t find a post about it.
I want to know the AVERAGE of the cells in column ‘value’ depending on the ‘name’. Until now, I used to order column ‘Name’, so =AVERAGE(B1:B3) for µ and B4:B5 for ß, but I need to order my data constantly using other columns. Therefore, I would like to know how to select cells depending of the value of another cell in the same row. Something like AVERAGE in B1:B5 (the whole spreadsheet) WHERE column A = µ.
Could you help me?
A: NAME B: VALUE µ 50 ß 90 µ 10 µ 7 ß 65