CODEWITHSUNDEEP
arraysif-statementgoogle-sheetsaveragespreadsheet
Bocho Todorov
Bocho Todorov

Reputation: 429

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

Upvotes: 1

Views: 43

Answers (1)

player0
player0

Reputation: 1

try:

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

Upvotes: 2

Related Questions