Exam 77-888: Microsoft Excel Expert 2010 2. Applying Formulas and Functions 2.3. Data summary: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, and AVERAGEIFS Formulas -> Function Library->More Functions -> Statistical ->COUNTIFS COUNTIFS Function How many cheap products are less than $3.50, net more than $500.00 in daily sales?   COUNTIFS lets you calculate the answer based on two (or more) conditions: the net price and the daily sales.   1. Try This: COUNTIFS Select Cells: $C$1:$C$58 Name the Range: Net. In Cell D63 type: COUNTIFS for Cheap Products with sales greater than $500.   Now, select Cell E63. Go to Formulas -> Function Library . Go to More Functions->Statistical Select ->COUNTIFS. Enter Criteria_range1: Net Enter Criteria1: <3.50 Enter Criteria_range2: Revenue Enter Criteria2: >500   2. What Do You See? The formula is: =COUNTIFS(Net,"<3.50",Revenue,">500")