View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Autosum Calculating Wrong

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?