Formulas -> Function Library->Math and Trig -> SUMIFS

SUMIFS: Add Another Criteria

What is the sum if you added sales greater than 500 AND less than 1000?

 

3. Try This: Add Another Criteria

Select Cell D61.
Type: SUMIFS All Sales Greater than $500 and Less than $1000
Select Cell E61.

Go to Formulas -> Function Library.

Go to More Functions->Math and Trig .

Select SUMIFS.

Enter the Sum_Range: Revenue

Enter Criteria_range1: Revenue

Enter Criteria1: >500.

 

Add another Criteria:

Enter Criteria_range2:Revenue

Enter Criteria2: <1000

 

3. What Do You See?

The formula in this example is:

 =SUMIFS(Revenue,Revenue,">500", Revenue,"<1000")

 

Memo to Self: The formula has no line breaks.

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.3. Data summary: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, and AVERAGEIFS