Hi,

Is it possible to perform a sumif or averageif where instead of selecting the sum/average range I'm able to use MATCH to choose which column to use.

For example, averageifs as standard:

=AVERAGEIFS(I:I,M:M,A2)

=MATCH(B2,1:1,0) - gives the result 9 (column I)

I'd like to use the match above to replace the "I:I" in the averageifs

Is this possible, or does anyone have a better/alternate solution?

Thanks