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

  
graphuc2
graphc2
graphci1

Formulas ->Function Library->More Functions -> Statistical ->AVERAGEIFS

AVERAGEIFS Function

Last one: What is the Average sales for the cheap products that sold more than $300 per day?

 

AVERAGEIFS lets you calculate the average based on two or more conditions: the example on this page uses the net and the revenue.

 

1. Try This: AVERAGEIFS

In Cell D77 type: Average Daily Sale for Cheap Products Greater than $300.

 

Now, select Cell E77.

Go to Formulas ->Function Library.

Go to More Functions->Statistical.

Select AVERAGEIFS.

Enter the Average_range: Revenue

Enter Criteria_Range1: Revenue

Enter the Criteria1: >300

Enter Criteria_Range2: Net
Enter the Criteria2: <3.25
Click OK.

2. What Do You See? The formula is

=AVERAGEIFS(Revenue,Revenue,">300",Net,"<3.25")

 

  b