| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trying to write function to find data in last row in 1 column | Excel Discussion (Misc queries) | |||
| how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
| find a specific value in a column and write another column | Excel Discussion (Misc queries) | |||
| how to write function to find max deviation from specific number . | Excel Worksheet Functions | |||
| Write formula to add "1" to each number in a column | Excel Worksheet Functions | |||
Hybrid Mode
