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)