How To Find Average In Excel

H

Wondering how to find average in Excel? Learn about this simple process in this article.

Will you believe us when we tell you that there are different ways of AVERAGE in excel and different ways to take out values? The following methods are the ways with which you can take out the average.

  • AVERAGE
  • AVERAGEA
  • AVERAGEIF

How To Find Average In Excel

AVERAGE

Microsoft Excel uses the AVERAGE function to find the arithmetic mean which is also the most accepted average in the world. The function generates a number that represents a typical value from a distribution, range or even a list of numbers. Calculate all the numbers in the list and divide the total by the number of values and you have the answer.

The function of AVERAGE is straightforward. The syntax is:

=AVERAGE(number1, [number2],…)

Ranges or cell references may be used instead of values.

The AVERAGE function can handle up to 255 arguments, which may be a cell, value, range, or reference. 

The following formula calculates the average of the numbers 100, 95, and 80.

=AVERAGE(100,95,80)

Formula :=AVERAGE(100,95,80)

To calculate the average of values in cells B2, B3, B4, and B5 enter:

=AVERAGE(B2:B5)

Type it directly into the formula bar or cell, or simply select it on the worksheet by selecting the cell in the range, and dragging the mouse to the last cell in the range. 

Type it directly into the formula bar or cell, or simply select it on the worksheet by selecting the cell in the range, and dragging the mouse to the last cell in the range. 

To calculate the average of non-contiguous or non-adjacent cells, hold the Control key while selecting. 

If you are typing the cell references directly into the cell or formula bar, non-contiguous references are separated by commas. For example 

=AVERAGE(B2:B5,B8)

If you are typing the cell references directly into the cell or formula bar, non-contiguous references are separated by commas.

Also Read
How to apply Round Off Formula in Excel
How to use If Formula in Excel
How to calculate Age in Excel

Remarks

When using the AVERAGE function, keep the following things in your mind.

  • Text values and empty cells are ignored.
  • Zero values are included. 

AVERAGEA

Another answer to how to find average in ms excel is with the help of this feature.

To eliminate this discrepancy, the AVERAGEA function is used to include all values within a distribution, including text. The formula to find the average in excel:

=AVERAGEA(value1, [value2],…)

A range of cell references is used instead of explicit values.

AVERAGEA evaluates text values as zero, while the logical value TRUE is evaluated as 1. The logical value FALSE is considered a zero. 

AVERAGEIF

There are ways to find the average of only the numbers that satisfy certain criteria. With this function, Excel looks within the specified range and then finds the arithmetic mean of the cells that meet that condition.

The syntax of the AVERAGEIF function is:

=AVERAGEIF(range,criteria,[average_range])

  • The range is the location where we can expect to find cells that meet the criteria.
  • The criteria are the value or expression that Excel should look for within the range.
  • Average_range is an optional argument. This is the range of cells where the values to be averaged are located. If the average_range is omitted, the range is used.

With these average formulas in Excel, you can easily find calculate and do your work without any problem or hurdle. Learn these processes and understand them so that you are able to perform them well.

CONCLUSION

Average is only one of the many operations that MS Excel is capable of performing. If you have a solid understanding of concepts like pivot tables and how to use VLOOKUP in Excel, many time-consuming tasks can be completed in a matter of seconds.

Easy sheet is a tech blog where you can find fantastic Excel hacks, tips, and tricks. Our aim is to make Excel more accessible to newbies and to provide them with Easy Sheet as a solution for all of their questions.

We are the ideal place to go for help with anything connected to Microsoft Office, including Excel, Word, PowerPoint, Publisher, and more!

About the author

Gaurav Singh Rawat

Add comment