Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.3 Apply Conditional Logic in Functions: Apply The SUMIF Function     Summarize the Data What is the sum of the product sales if you look at the Eggs, only?   1. Try This: SUMIF Add a label to Cell D71: SUMIF Eggs Select Cell E71. Go to Formulas -> Function Library. Go to Math and Trig->SUMIF. Enter the Range: Product Enter the Criteria: Eggs (Microsoft Excel will add quotes because this is Text) Enter the Sum_range: Revenue. Click OK. 2. What Do You See? The SUMIF function calculates the sum based on your criteria. In this example, the Criteria is the product: Eggs.   The Sum_range is Revenue. Excel will look in Column E, Cells E1:E70, and SUM the money for the Egg products.

Formulas -> Function Library->Math and Trig -> SUMIF