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