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


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;



Keep going...