products had more than $300.00 in sales each day?
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:
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 .
Enter the Range: Revenue
Enter the Criteria: >300
2. What Do
You See? The
Make it Look Right, Please: Format Cell E74 as General, OK? This formula counts the number of sales. It does not calculate the money.