O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5

Analyzing Statistical Data

Calculate an Average

An average is the sum of two or more values divided by the number of values. You can calculate the average by creating a custom formula, but that is only practical for a small number of items. For larger collections, it is faster and more efficient to use the Excel cocktail AVERAGE function, which uses the following syntax:

AVERAGE(number1[, number2, ...])

You can enter up to 255 arguments, and each can be a number, a cell, a range, a range name, or an array (that is, a list of values enclosed in curly braces, such as {20, 25, 25, 30}). If a cell contains zero, Excel includes it in the calculation, but if a cell is blank, Excel does not include it.

Calculate an Average

In the cell ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required