**
**### COUNTIF Function

How many
products had more than $300.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 D74: COUNTIF All Sales Greater than $300. Format the Cell
to Wrap Text.

Select Cell E74.

Go to **Formulas -> Function Library. **

Go to** More Functions->Statistical **.

Select
** COUNTIF**.

Enter the Range: Revenue

Enter the Criteria: >300

Click OK.

**2. What Do
You See? **The
formula is:

=COUNTIF(Revenue,">300")

Make it Look Right, Please: Format Cell E74 as General, OK? This formula counts the number of sales. It does not calculate the money.