O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

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

AVERAGEA()

Syntax. AVERAGEA(value1,value2,...)

Definition. This function calculates the average of the values in an argument list. Not only numbers but also text and logical values (TRUE and FALSE) are included in the calculation.

Arguments

  • value1 (required) and value2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) for which you want to calculate the average

Note

The arguments can be numbers, names, arrays, or references.

Tip: Show a zero in cells with zero values

Remember that empty cells are treated differently from cells with the value 0. Empty cells are not counted, but 0 values are. If you activate the zero values option for cells with the value 0, you can see which cells are really empty and which contains ...

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