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")