I am averaging all the numbers including the zeros. My concern is that 74/25
is 2.96, but Excel return 2.64 as the result
--
Thanks,
Greg


"Jim Thomlinson" wrote:

Are you trying to average all of the values or all of the non-zero values???
Average will include the zeros...
--
HTH...

Jim Thomlinson


"gja63" wrote:

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