Autosum Calculating Wrong
You're welcome, have a great day!
Kelly P wrote:
The problem is within the rounding. Thanks for your help.
"Bob I" wrote:
Check the actual numbers in each that are being summed, NOT the rounded
ones you are viewing in the sheet.
Kelly P wrote:
On my spreadsheet I have cells that reference calculated totals on other
worksheets, at the bottom of the column I have it auto summing the column.
It's not adding correctly, it's currently 2 cents off from what it should be.
Any ideas on how to get it to add it correctly?
|