How many
products had more than $500.00 in sales each day? COUNTIF
lets you count the products based on your criteria. This function works with the numbers in the
Revenue data in Column E. 1. Try This:
COUNTIF Add a
label to Cell D62: COUNTIF greater than $500. Format the Cell
to Wrap Text.
Select Cell E62.
Go to Formulas -> Function Library.
Go to More Functions->Statistical .
Select
COUNTIF.
Enter the Range: Revenue
Enter the Criteria: >500 2. What Do
You See? The
formula is: =COUNTIF(Revenue,">500")
Go to Formulas -> Function Library-> More Functions ->
Statistical ->COUNTIF
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.3. Data summary: SUMIF, SUMIFS,
COUNTIF, COUNTIFS, AVERAGEIF, and AVERAGEIFS |
|
| |
