Formulas ->Function Library->More Functions ->
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
1. Try This:
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.
Enter Criteria_Range1: Revenue
Enter the Criteria1: >300
Enter Criteria_Range2: Net
Enter the Criteria2: <3.25
2. What Do
You See? The formula is