Home » Finance Trading Basics » How Average in Excel?

How Average in Excel?

Sarah Jenkins • • 6 min read
How Average in Excel?

Use AutoSum to quickly find the average
  1. Click a cell below the column or to the right of the row of the numbers for which you want to find the average.
  2. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.

What is the formula for average in Excel?

Description. Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

What does average () do in Excel?

The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants. A number representing the average. number1 - A number or cell reference that refers to numeric values.

Sarah Jenkins
Author

Sarah Jenkins

Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.