Search code examples
arraysif-statementgoogle-sheetsaveragespreadsheet

Get an average for each column depending on the value in another column

I have the table bellow where each column from J to M are prices for a certain activities.

Column I is the Size

I want to create a new table where automatically to be calculated the AVERAGE for each column where "I" is equal to something (112, 132, 160 and so on...)

enter image description here

Solution

  • try:

    =AVERAGEIFS(J5:J19; $I5:$I19; 132)