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...)

CodePudding user response：

try:

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