|
|
| Sum
based on Multiple Criteria |
The
following formula returns the sum of D2:D10, where the
corresponding value in B2:B10 equals the value in F2, and the
correspondng value in C2:C10 equals the value in G2...
=SUMIFS(D2:D10,B2:B10,F2,C2:C10,G2)
For versions prior to Excel 2007 for the PC and Excel 2008 for
the Mac:
=SUMPRODUCT(--(B2:B10=F2),--(C2:C10=G2),D2:D10)
Based on the sample data, the formulas return 10. Sample
Workbook |
|
|
