Sum Based on Multiple Criteria
The following formula returns the sum of C2:C10, where the corresponding value in A2:A10 equals the value in E2, and the correspondng value in B2:B10 equals the value in F2...
=SUMIFS(C2:C10,A2:A10,E2,B2:B10,F2)
For Excel 2003 and prior versions, the following formula can be used...
=SUMPRODUCT(--(A2:A10=E2),--(B2:B10=F2),C2:C10)
Based on the sample data, the formula returns 10.
Sample Workbook: Download