This is the top three lines in a list of 8200 records.You want an average of the number of speeding tickets for Red Toyota Priuses.Which is the correct formula?

A)=AVERAGEIFS(A2:A8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
B)=AVERAGEIFS(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
C)=AVERAGEIF(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
D)=AVERAGEIF(E2:E8201,"Red","Toyota","Prius")

Question

This is the top three lines in a list of 8200 records.You want an average of the number of speeding tickets for Red Toyota Priuses.Which is the correct formula?

A)=AVERAGEIFS(A2:A8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius") 
B)=AVERAGEIFS(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius") 
C)=AVERAGEIF(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius") 
D)=AVERAGEIF(E2:E8201,"Red","Toyota","Prius")

Quizplus · Accepted Answer

The formula should be AVERAGEIFS (plural), not AVERAGEIF (singular), as we are looking for an average of multiple conditions. The correct range for the number of speeding tickets is column E, not A. Therefore, option B is the correct formula. Option A has the correct AVERAGEIFS formula but incorrect range for speeding tickets. Option C has the correct range for speeding tickets but incorrect formula (AVERAGEIF instead of AVERAGEIFS). Option D is not a valid formula for averaging with multiple conditions.

This Is the Top Three Lines in a List of 8200