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

[lallen]

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

 

[Pete_UK]

Try this:

=AVERAGE(A1:A20)

Hope this helps.

Pete

 

[Mike Middleton]

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