AVERAGEIFS w/ multiple & changing criteria - Please help!

Hello,

For a project I am trying to analyze a fleet of cars based on several criteria.

I need to be able to calculate several metrics based on a drop-down list of those criteria.

Basically I have three criteria (Year, Model, Make) of the cars in drop down lists so that you can select different models from different years, and so on. I need to have cells that automatically calculate the averages of, for example, purchase price, based on the contents of the criteria cells.

I've attached an example excel file where my issue can better be understood. Please help! Thanks!

Try these:

=LOOKUP(2,1/('Car Information'!$D$3:$D$11=B2)*('Car Information'!$B$3:$B$11=C2)*('Car Information'!$C$3:$C$11=D2),'Car Information'!$E$3:$E$11)

=LOOKUP(2,1/('Car Information'!$D$3:$D$11=B2)*('Car Information'!$B$3:$B$11=C2)*('Car Information'!$C$3:$C$11=D2),'Car Information'!$G$3:$G$11)

=LOOKUP(2,1/('Car Information'!$D$3:$D$11=B2)*('Car Information'!$B$3:$B$11=C2)*('Car Information'!$C$3:$C$11=D2),'Car Information'!$F$3:$F$11)

Sorry - I misread the question - ignore this.

Try again!

=AVERAGEIFS('Car Information'!$E$3:$E$11,'Car Information'!$D$3:$D$11,B2,'Car Information'!$B$3:$B$11,C2,'Car Information'!$C$3:$C$11,D2)

=AVERAGEIFS('Car Information'!$G$3:$G$11,'Car Information'!$D$3:$D$11,B2,'Car Information'!$B$3:$B$11,C2,'Car Information'!$C$3:$C$11,D2)

=AVERAGEIFS('Car Information'!$F$3:$F$11,'Car Information'!$D$3:$D$11,B2,'Car Information'!$B$3:$B$11,C2,'Car Information'!$C$3:$C$11,D2)

No problem.