When I use =average on a column of numbers I'm getting the wrong result. By using sum and then dividing the number of cells i get an entirely different answer. Excel says 5.49. I say 10.64. I know mine to be right because when I do a standard deviation from the mean I get results that make sense. The other number simply doesn't work. So where is excel getting it?