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 D64
type: Average Daily Sale for Cheap Products.
Now, select Cell E64.
Go to
Formulas ->
Function Library.
Go to More
Functions>Statistical.
Select
AVERAGEIF.
Enter the Range: Net
Enter the Criteria: <3.50 Enter the
Average_range: Revenue 2. What Do
You See?
The formula is =AVERAGEIF(Net,"<3.50",Revenue)
Formulas -> Function Library->More Functions ->
Statistical ->AVERAGEIF
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.3. Data summary: SUMIF, SUMIFS,
COUNTIF, COUNTIFS, AVERAGEIF, and AVERAGEIFS |
|
| |
