Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003


Microsoft Excel 2003 Functions and Formulas

Get the Average of a Series

Summary: Display the average value of grades, monthly profits, yearly expenses, etc. in a Microsoft Excel 2003 spreadsheet.

Often when developing a Microsoft Excel 2003 spreadsheet you may need to calculate the average of a series of numbers. For example:

* The average amount of revenue a company brought in per month.

* The average test score of a student.

* The average cost to produce a product from several companies' plants.

To do so requires the =AVERAGE function. For example:


would result in the value:


You could combine this with the =round function to round the average to the nearest whole number, for example with grades:


The result:


You can also get the average of a series. For example, to get the average of cells A1 through A7:


Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Functions and Formulas page.

Print this tip.

- Subscribe!

Search the Site: