|
Excel: Sounds Good
Formulas -> More Functions ->
Statistical ->COUNTIFS How many
times did the cheap products, the ones that sell for less than
$3.50, net more than $500.00 in daily sales? COUNTIFS
lets you calculate the answer based on two
conditions: the net price and the daily sales. Try This:
COUNTIFS Select
Cells: $C$1:$C$58
Name the Range: Net.
In cell D62 type: COUNTIFS for Cheap Products with sales
greater than $500.
Now, select cell E62.
Go to Formulas -> More Functions.
Select
Statistical ->COUNTIFS.
Enter Criteria_range1: Net
Enter Criteria1: <3.50 Enter
Criteria_range2: Q1sales Enter
Criteria2: >500 What Do
You See? The
formula in this sample is:=COUNTIFS(Net,"<3.50",Q1sales,">500") |
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas:
3.4. Conditionally summarize data using a formula
3.4.1. Using SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, and AVERAGEIFS