In this article, you’ll learn about the Average functions in Microsoft Excel. Average functions we use when we want to judge the overall group performance. In Excel we can calculate average on the basis of numbers, criteria even more than one criteria. We have 4 types of Average functions in Microsoft Excel:-
AVERAGE Function:-
We use Average function to get the average of a group of numbers.
Let’s take an example and understand:-
We have student’s score data, in which we want to calculate average score.
Follow below given steps:-
AVERAGEA Function:-
We use this function to get the average of a group of numbers and Text
Let’s take an example and understand:-
We have student’s scores, and also, 2 students were absent on the day of examination. Now, we want to calculate average score for all students including those who were absent.
Follow below given steps:-
AVERAGEIF Function
AVERAGEIF function is used to return the average on the basis of a criterion.
Let’s take an example and understand:-
Similarly, we have student’s score data, and we want to calculate average numbers for those students who scored more than50 marks.
Follow below given steps:-
AVERAGEIFS Function
AVERAGEIFS function is used to return the average on the basis of multiple criteria.
Let’s take an example and understand
We have student’s scores semester-wise for every subject. Now, we want to calculate Average score in every semester for every student for every subject.
In data, we have drop down list of Student and, on the selection of Subject, average score should be changed accordingly.
Follow below given steps:-
Key take away:-
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.