How to Use the AVERAGEIF Function in Excel | Calculates the Average of Cells that Meet One Criteria

Excel, Word and PowerPoint Tutorials from Howtech
Excel, Word and PowerPoint Tutorials from Howtech
34.9 هزار بار بازدید - 4 سال پیش - In this video, we will
In this video, we will teach you how to use the AVERAGE IF function in Excel The AVERAGE IF function allows you to calculate the mean of a range based on a given criteria. So over here, we have a student marksheet, and let’s say we want to find out the average test score for Class A and B. For that, we will be using the Average IF function and use the criteria we have defined here, under the average heading, to determine the average test score of that class. So let’s move to the cell here and type in “equals to” followed by Average IF and brackets open. First, we have to define the range. For that, let’s select the cells with the class type defined in column D here. Let’s enter a comma and next we will define the criteria. In this case, we want to get the average score of Class A, so let’s use this cell as a reference. After that, let’s enter a comma and now we will select the average range. By doing this, whenever the formula finds a matching value from the test range we have defined here, it will determine the average from the corresponding cells. So, let’s select all the score values here in column C. You can select the range and average range in the formula and press F 4 on the keyboard to make it into an absolute reference. This will make it easier for copying and pasting the formula for the criteria below. Once you hit enter, the formula will automatically return the average test scores for Class A. Now let’s copy and paste the formula below, and since we didn’t make the criteria as an absolute reference in the formula, it will automatically pick up the criteria value in the cell here and return the average test score for Class B. That’s all! ❓💬 Is there any Excel function you would like to know more about? Let us know in the comments below. #HowTech #Excel -------------------------------------------------------------------------------------------------------------- ✅ All our announcements are available here t.me/howtechtv ✅ Commercial questions [email protected] ✅ Instagram www.instagram.com/howtechprojects ✅ Twitter twitter.com/howtechprojects
4 سال پیش در تاریخ 1399/08/05 منتشر شده است.
34,990 بـار بازدید شده
... بیشتر