ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I write the formula to find the mean in a column of number (https://www.excelbanter.com/excel-worksheet-functions/173653-how-do-i-write-formula-find-mean-column-number.html)

lallen

how do I write the formula to find the mean in a column of number
 
I have a column of values and want to find the mean. How do I write the
formula

Pete_UK

how do I write the formula to find the mean in a column of number
 
Try this:

=AVERAGE(A1:A20)

Hope this helps.

Pete

On Jan 18, 8:20*pm, lallen wrote:
I have a column of values and want to find the mean. *How do I write the
formula



Mike Middleton

how do I write the formula to find the mean in a column of number
 
lallen -

For example, if your data are in A2:A101, then in some other cell enter
=AVERAGE(A2:A101)

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"lallen" wrote in message
...
I have a column of values and want to find the mean. How do I write the
formula





All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com