**
**### 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.