Formulas -> Function Library->More Functions ->
cheap products that cost less than
$3.25 net more than $300.00 in daily sales?
COUNTIFS lets you calculate the answer based on two
(or more) conditions: the net price and the daily sales.
1. Try This:
Name the Range: Net.
In Cell D75 type: COUNTIFS for Cheap Products with Sales
Greater than $300.
Now, select Cell E75.
Go to Formulas -> Function Library
Go to More Functions->Statistical
Enter Criteria_range1: Net
Enter Criteria1: <3.25
E75 as General.
2. What Do
You See? The