New AVERAGE Functions in Excel 2007

 

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
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS

Image 1

 

image 2

 

AVERAGE Function:-

We use Average function to get the average of a group of numbers.

image 3

 

Let’s take an example and understand:-

We have student’s score data, in which we want to calculate average score.

image 4

 

Follow below given steps:-

  • Enter the formula in cell B13
  • =AVERAGE(B2:B10)
  • Press Enter

image 5

 

AVERAGEA Function:-

We use this function to get the average of a group of numbers and Text

image 6

 

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.

image 7

 

Follow below given steps:-

  • Enter the formula in cell B13
  • =AVERAGEA(B2:B10)
  • Press Enter

image 8

 

AVERAGEIF Function

AVERAGEIF function is used to return the average on the basis of a criterion.

image 9

 

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.

image 10

 

Follow below given steps:-

  • Enter the formula in cell B13
  • =AVERAGEIF(B2:B10,”>50″,B2:B10)
  • Press Enter

image 11

 

AVERAGEIFS Function

AVERAGEIFS function is used to return the average on the basis of multiple criteria.

image 12

 

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.

image 13

 

Follow below given steps:-

  • Enter the formula in cell B13
  • =AVERAGEIFS(D2:D19,B2:B19,A24,C2:C19,B24)
  • Press Enter

image 14

 

Key take away:-

  • Average family functions
  • Uses of Average functions
  • Comparison between AVERAGE and AVERAGEA function
  • Comparison between AVERAGEIF and AVERAGEIFS function

 

image 48

 

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



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>