QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Calculate Average in Excel?

By Neha T Leave a Comment

Excel has provided some particular functions to calculate average. Like it has AVERAGE, AVERAGEA, AVERAGEIF functions which returns the average of the numbers fed to the functions in the argument. The average is the arithmetic mean of the considered numbers.

In this section, we will discuss different methods to calculate the average. We will also discuss the different average functions provided by Excel. The syntax of the AVERAGE function is as follow:

AVERAGE(number1, [number2], …)

number1 is the first number of which you need average.

number2 is an optional number which if present is reviewed for computing the average.

Maximum 255 numbers can be fed as an argument to the AVERAGE function.

Steps to Calculate Average in Excel 2016:

Manually Calculating Average in Excel

The example below shows the calculation of the average manually. It is simply the addition of the numbers, divided by the count of that numbers.

Calculate Average in Excel - 1

Using Other Excel Formulas to Calculate Average

For calculating the average, we have used two excel functions SUM and COUNT. The SUM function returns the addition of all the numbers from A2 through A7 (in this example) which is then divided by the count of numbers from A2 through A7 returned by the COUNT function. This formula returns the average of the numbers from cell A2:A7.

Calculate Average in Excel - 2

AVERAGE Function in Excel

AVERAGE() is an Excel function specifically for calculating the average of the numbers fed to the function in arguments. In the example below, the AVERAGE() function calculate the average of the numbers from cell A2 through A7.

Calculate Average in Excel - 3

The AVERAGE() function do not consider the logical values like TRUE or FALSE, text or an empty cell while calculating the average of the numbers. Like in the example below, the AVERAGE() function calculate the average of three numbers only i.e. 19, 25, 18 and ignore the cells with logical values, text & empty cells.

Calculate Average in Excel - 4.1

You can also manually feed the numbers to AVERAGE() function as shown in the example below.

Calculate Average in Excel - 4

The AVERAGE() function also accepts cell range along with the numbers in its argument as shown in the image below.

Calculate Average in Excel - 5

AVERAGEA() Function in Excel

The AVERAGEA function in Excel calculates the average of the numbers fed to it in the argument. Along with this it also considers logical values and cells containing texts. But, AVERAGEA function does not consider the empty cells.

AVERAGEA function considers ‘0’ for logical value FALSE and cell containing text value. And for the logical value TRUE it takes 1.

In the example below, the AVERAGEA function calculates average as (19+25+0+18+1+0)/6 i.e. the cell value for ‘FLASE’ & text ‘Jhon’ is taken 0 and for TRUE it is considering 1.

Calculate Average in Excel - 6

AVERAGEIF() Function in Excel

The AVERAGEIF function also returns the average of the numbers based on the conditions specified in the argument. The syntax of the AVERAGEIF function is as follow:

AVERAGEIF(range, criteria, [average_range])

range: is the number of cells to average, if the average_range is not present.

criteria: is the condition evaluated to find which cells are to be averaged.

average_range: the actual cells that are averaged.

In the example below, you can observe that the AVERAGEIF function calculate the average of those number of students whose favourite fruit is not equal to Grapes.

Calculate Average in Excel - 7

So, this is all about the various methods to calculate the average in Excel. Hope the content is useful. Keep reading.

You Might Also Like:

Calculate Age in Excel feature imageHow to Calculate Age in Excel? Calculate percentage Featured ImageHow to Calculate Percentage in MS Excel 2016? feature imageHow to COUNTIF in MS Excel 2016? generate a random number in excel featured imageHow to Generate Random Number in Excel? count unique values featured imageHow to Count Unique Values in Excel 2016? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? Merge Cell in Excel feature imageHow to Merge Cells, Columns & Rows in Excel?

Leave a Reply Cancel reply

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

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Convert Handwriting to Text in OneNote 2016?
  • How to Upload and Download File in Google Drive?
  • How to Delete Trash in Gmail?
  • How to restore gmail contacts
  • How to Delete Notebook in OneNote?

Copyright © 2023 · QueHow · Contact Us