In this post, we will share a tutorial on using the AVERAGEIFS function in Excel. This function helps find the average of numbers that meet one or multiple criteria.
We will walk you through the process step by step, with an example of finding the average sales numbers greater than 20 and less than 40. By the end of this tutorial, you will have a solid understanding of how to use this function in your own work.
Step 1: Understand the Scenario
Our sheet includes a dataset with the product, their store, and sales. We will work on finding the average sales numbers greater than 20 and less than 40.
Step 2: Use the AVERAGEIFS Function
- Start the function by writing =AVERAGEIFS( in a cell where you want to make the calculation.
- In the first argument, select the range of numbers where the average will be calculated. In this example, the range is from cell C22 to C30 (C22:C30). Then enter the first criteria range, which is the same as the average range in this example (C22:C30).
- Now enter the first criteria, which is “>=20”. Then, enter the second criteria range. Again, it is the same as the average range (C22:C30).
- In the next argument, enter the second criteria, which is “<=40“. Close the parenthesis, and the completed formula should look like this: =AVERAGEIFS(C22:C30,C22:C30, “>=20″,C22:C30,”<=40”)
- Press Enter to get the result. The result should be the average of the sales numbers that meet the criteria of being greater than 20 and less than 40.
Conclusion
By following the steps outlined in this tutorial, you should now understand how to use the AVERAGEIFS function in Excel to find the average of numbers that meet specific criteria. Our Youtube video on this function exhibits additional examples to help you better understand how to use this function in other scenarios. So, check it out!
