Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.3 Apply Conditional Logic in Functions: Apply The COUNTIF Function     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.

Go to Formulas -> Function Library-> More Functions -> Statistical ->COUNTIF