'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

arraysif-statementgoogle-sheetsaveragespreadsheet


Solution 1:[1]

try:

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0

Related Questions