View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default Excel Average function not returning expected result

It sounds to me as if some of your data may actually be text. If you use
SUM(your range) do you really get 74?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"gja63" wrote in message
...
Hi all:

I have a column of 25 numbers that include zeros that total 74. I have
applied the average function and rounded the result to two decimal places.

ROUND(AVERAGE (number 1,number 2...),2).

The result that I am receiving from excel is 2.64. When I use a
calculator
the result is 2.96. What am I doing wrong?

--
Thanks,
Greg