### AVERAGEIF Function

What is
the Average daily sales for the cheap products?

**
AVERAGEIF** lets you figure the average based on your criteria.
This formula will look up a number in a **Range** of prices:
that's the Filter. The cells that you select to calculate the
Average is called the** Average_Range**.

**1. Try This:
AVERAGEIF**

In Cell D76
type: Average Daily Sale for Cheap Products.

** **

Now, select Cell E76.

Go to
**
Formulas ->
** ** Function Library****.
**

Go to **More
Functions>Statistical.
**

Select **
AVERAGEIF**.

Enter the Range: Net

Enter the Criteria: <3.25

Enter the
Average_range: Revenue

Click OK.

**
****
**

2. What Do
You See? The formula is

=AVERAGEIF(Net,"<3.25",Revenue)