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:
In Cell D76
type: Average Daily Sale for Cheap Products.
Now, select Cell E76.
Go to More
Enter the Range: Net
Enter the Criteria: <3.25
2. What Do
You See? The formula is
Formulas -> Function Library->More Functions ->