Summarize the Data What is the sum of the product sales if you look at the Eggs, only?   Try This: SUMIF Add a label to Cell D59: SUMIF eggs Select Cell E59. 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. 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:E58, and SUM the money.

Formulas -> Function Library->Math and Trig -> SUMIF Exam 77-888: Microsoft Excel Expert 2010 2. Applying Formulas and Functions 2.3. Data summary: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, and AVERAGEIFS