**
**### COUNTIF Function

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")