|
|
| Average
based on a Single Criteria |
The following formula returns the average for C2:C10, where
the
corresponding value in B2:B10
equals the value in E2...
=AVERAGEIF(B2:B10,E2,C2:C10)
For versions prior to Excel 2007 for the PC and Excel 2008 for the Mac:
=AVERAGE(IF(B2:B10=E2,C2:C10))
| 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 |
|
|
