» Summing Values from Two Ranges, Based on Two Criteria
Columns A & B contain a list of candy eaten last week and the calories corresponding with each item.
Columns C & D contain the equivalent information regarding fruit and vegetables.
We want a total of the calories gained last week by eating the food items specified in column F.
Use the SUMPRODUCT function as shown in either of the following formulas:
Use the SUMIF function as shown in the following formula:
|Screenshot // Summing Values from Two Ranges, Based on Two Criteria |