What Is Excel Average Function –A Quick Guide

An average is the most used mathematical function in our daily life.

It can be during the score calculation or financial maths, we end up using the average most of the times.

Excel AVERAGE function can come handy during the calculations.

Let’s see how to use it in detail…

1. What is the AVERAGE Function?
2. What is the Syntax?
3. How to use it with an example?

1. What is the AVERAGE Function?

An AVERAGE function can be used to find the average of values supplied as arguments to it.


2. What is the Syntax?

=AVERAGE(number1,[number2],…)

  • number1  = (Required) A number, a range of cells which contain numbers or a single cell which contain a number.
  • [number2] = (Optional) A number, a range of cells which contain numbers or a single cell which contain a number.

Note :

  • The formula can take up to 255 arguments.
  • Any empty cells supplied will be ignored.
  • Text representations of numbers and logical values that are typed directly into the list of arguments are counted.
  • Text, logical values, or empty cells in a range or cell reference are ignored but cells with the value zero are included.

3. How to use it with an example?

Assuming we have the data of a few students and are required to find the average of their scores.

Let’s see how to do it!!!

Excel Average function Data.PNG

1. Finding the average of  numbers available in the provided range.
2. Finding the average of  numbers available in the provided range along with additional arguments supplied.

1. Finding the average of numbers available in the provided range

Excel Average function 1

**Explained**

=AVERAGE(B3:B7)
  • B3:B7 = range of cells containing numbers for which the average has to be calculated.

2. Finding the average of  numbers available in the provided range along with additional arguments supplied

 

Excel Average function 2.PNG

**Explained**

=AVERAGE(B3:B7,"12","2")
  • B3:B7 = range of cells containing numbers for which the average has to be calculated.
  • “12”,”2″ = Additional arguments supplied.

 

Hope it has helped you…    

Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply