Average function in excel

Average function in excel

This tutorial will give you a detailed description regarding the Average function in Excel. The average function is the most used function after AutoSum. This tutorial will give you knowledge regarding what is average function? What are the uses of average function? What is the formula to calculate average? What is the purpose of using average function? When and where can average function be used? Requirements and non-requirement for calculate average? What are the ways or methods to calculate average? Let’s take a detailed look into this function.

MS Excel में Average फंक्शन क्या है?

The average function is used to calculate the arithmetic mean of the numbers, arguments, cell references, range, etc. The average function is the inbuilt function in Microsoft Excel. It is a statistical function in Excel. It is entered in the formula bar of Excel. Whenever we hear the word average the first thing that comes in mind is the arithmetic mean of the numbers. The average function can handle up to 255 arguments.

Average function का उद्देश्य क्या है?

The purpose of average function is to get the average of group of numbers. Another purpose of using average function is to get the average numeric value for our representation. Average function is a worksheet function which is used to carry out functions in our worksheet. This function makes it easier for mathematical calculation. This function is the most required function while working in the worksheet.

Average function का calculate करने के लिए क्या formula है?

There is a particular syntax that is to be carried out while performing or calculating average for the given numbers. Like to calculate average we will add all the numbers and then divide the total by the count numbers. For example, there are five numbers 7,8,9,10,11 we need to count the average for this function. We will do so by adding all the above numbers (7+8+9+10+11) will be 45. The total numbers are 5. So the arithmetic mean will be 45 divide by 5 which will be 9.

However to calculate average in excel we will use the syntax

Average (Number1, [Number 2]…)
Where number 1 and number 2 are the numeric values you want to find average of. The number 1 is required to be filled and rest all is optional. You can add 255 numbers in a single formula.
Suppose we want to count the above example in Excel then we must syntax it as =Average (A1, A2, A3, A4, A5) the answer will be the same 9.

You can also insert range of cells. Like for the above example you can count average by using the following syntax

Points to be kept in mind while calculating Average functions:

  • The arguments should only be of numbers.
  • The number 0 will be included while calculating the average.
  • Blank cell will not be taken into consideration while calculating average.
  • The cell should not contain text or any logical values, they will be ignored.
  • If we want to include text representation of numbers then we must use AVERAGEA function.
  • If we want to calculate the average of the numbers that meet certain criteria then we must use the AVERAGEIF function.
  • The = equal to sign is a must while carrying out average function, otherwise other function will be enabled.

आपको MS Excel में Average function कहाँ मिलेगा?

You will find the Average function in the AutoSum drop down menu. AutoSum drop down menu is at the home ribbon editing group with the AutoSum name and sign ∑.

Another place to find Average function is when you press fx function above the spreadsheet and below the ribbon. As you press this function an Insert function dialog box will open. There you can select the function average.

The third place you find Average function is in the formula ribbon. There you find AutoSum and as u click on the drop down it will show Average. You can also go into the function library group where you find more function. More function will show statistical and as you press the right arrow key it will show the average function.

However the shortcut to insert average function through keyboard is Shift + F3. This shortcut key will open the insert function dialog box and you select average function.


The above tutorial gave you the basic idea about the average function use in Excel. I hope you might have understood about the Average Excel function. Just remember that by term average is Excel is the arithmetic mean and not the central tendency mean or the standard deviation mean. It is just a simple mean or average to calculate the middle or the center part of the worksheet.