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 ->AVERAGEIFS AVERAGEIFS Function One last question: What is the Average sales for the cheap products that sold more than $500 per day?   AVERAGEIFS lets you calculate the average based on two or more conditions: the example on this page uses the net and the revenue.   1. Try This: AVERAGEIFS In Cell D65 type: Average Daily Sale for Cheap Products greater than $500.   Now, select Cell E65. Go to Formulas ->Function Library. Go to More Functions->Statistical. Select AVERAGEIFS. Enter the Average_range: Revenue Enter Criteria_Range1: Revenue Enter the Criteria1: >500 Enter Criteria_Range2: Net Enter the Criteria2: <3.50 2. What Do You See? The formula is =AVERAGEIFS(Revenue,Revenue,">500",Net,"<3.50")