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:
=average(99,89,84,92,90)
would result in the value:
90.8
You could combine this with the =round function to round the average to the nearest whole number, for example with grades:
=round(average(99,89,84,92,90),0)
The result:
91
You can also get the average of a series. For example, to get the average of cells A1 through A7:
=round(average(a1:a7),0)
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.
Search the Site: