# [b]My averages are incorrect - help please![/b]

#### miltinstlouis

##### New Member
When I average a column of numbers the averages are incorrect. I know it has something to do with how Excel stores the numbers in memory - but I'm not sure what the fix is - maybe the round function. All help is GREATLY appreciated!!

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
If U R averaging ranges including zeroes, that is the problem. There are formulas you can write to discount the zero values.

examples:
=SUM(
#VALUE!

I am simply summing a column of numbers that are dollars and cents and then using the average function. When I add up the columns with a calculator I do not get the same totals.

Is there a simple fix?

Other than the zero issue, I don't know of a problem with Excel's average function.

It is probably the case that excel is rounding up "hidden" decimals.

to eliminate that problem, use the Round() function or any of its relatives. (See Excel Help)

Here some other info:
http://www.mrexcel.com/archive2/6300/6975.htm

http://www.mrexcel.com/archive2/18200/20674.htm

http://www.xldynamic.com/source/xld.Rounding.html

miltinstlouis said:
I am simply summing a column of numbers that are dollars and cents and then using the average function. When I add up the columns with a calculator I do not get the same totals.

Is there a simple fix?

What are the results these two engines yield?

Replies
2
Views
150
Replies
3
Views
168
Replies
2
Views
135
Replies
3
Views
105
Replies
1
Views
111

1,203,655
Messages
6,056,571
Members
444,877
Latest member
kat517

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back