|
|
| Average
based on Multiple Criteria |
The following formula returns the average for D2:D10, where
the corresponding value in B2:B10 equals the value in F2, and the
corresponding value in C2:C10 equals the value in G2...
=AVERAGEIFS(D2:D10,B2:B10,F2,C2:C10,G2)
For versions prior to Excel 2007 for the PC and Excel 2008 for the Mac:
=AVERAGE(IF(B2:B10=F2,IF(C2:C10=G2,D2:D10)))
| Note
that this is an array formula, which needs
to be confirmed with
CONTROL+SHIFT+ENTER for the PC or COMMAND+RETURN for the Mac. |
Based on the sample data, the formulas return 80. Sample
Workbook |
|
|
