|
|
#1
02-24-2015, 07:13 PM
|
|||
|
|||
Average function not averaging
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? 
|
| Tags |
| average |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 #REF! Error in calling VBA function disappears when function is copied
|
lcaretto | Excel Programming | 2 | 05-26-2014 07:19 PM |
|
Is this where i use the "average if function"?????
|
CSTEIGER | Excel | 2 | 11-21-2013 06:25 PM |
| Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
| Average for the month | joflow21 | Excel | 4 | 10-21-2013 06:57 AM |
| 'AVERAGE' Formula | nfphilpot | Excel | 3 | 11-24-2010 02:19 PM |
Windows 7 64bit 
Office 2007
Threaded Mode