Summarize the Data
the sum of the product sales if you look at the Eggs, only?
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
Excel will add quotes because this is Text)
Enter the Sum_range: Revenue.
2. What Do You See?
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.