graphic1

 

 

Exam 77-428 Microsoft Excel 2013 EXPERT
3. Create Advanced Formulas
3.1   Apply Functions in Formulas: Use SUMIFS

  
graphci2

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

SUMIFS Function

What is the SUM of the products with more than $300.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 D72.

Type: SUMIFS All Sales Greater than $300. Format the Cell to Wrap Text.

Select Cell E72.

Go to Formulas -> Function Library.

Go to Math and Trig->SUMIFS.

Enter the Sum_Range: Revenue

Enter the Criteria_range1: Revenue

Enter Criteria1: >300.
Click OK.

 

2. What Do You See? The formula is;

=SUMIFS(Revenue,Revenue,">300")

 

Keep going...

graphic1