View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default 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?