|
|
| Maximum
based on Multiple Criteria |
The
following formula returns the largest value from 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...
=MAX(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 formula returns 80. Sample
Workbook
|
|
|
