View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default 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