Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.3. Data summary: SUMIF, SUMIFS,
COUNTIF, COUNTIFS, AVERAGEIF, and AVERAGEIFS
Formulas -> Function Library->Math and Trig -> SUMIFS What is
the SUM of the products with more than $500.00 in sales each day? SUMIFS
lets you use several Criteria in the formula. This function works with the numbers, not the text. 1. Try
This:
SUMIFS Select Cell D60.
Type: SUMIFS All Sales Greater than $500. Format the
Cell to Wrap Text.
Select Cell E60.
Go to Formulas -> Function Library.
Go to Math and Trig->SUMIFS.
Enter the Sum_Range: Revenue
Enter the Criteria_range1: Revenue Enter
Criteria1: >500. 2. What
Do You See? The formula is; =SUMIFS(Revenue,Revenue,">500") Keep
going.... |
|
| |
