View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default SUMS Do not match

Look he

http://www.mcgimpsey.com/excel/pennyoff.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"rvk man" <rvk wrote in message ...
|I have a spreadsheet that totals many numbers in columns. Then the total for
| each column is added to together to get "TOTAL". I also total on the right
| side by totaling the SAME numbers by row. All the row numbers added together
| and then a sum is listed by each of these columns. The numbers should add up
| to the same amount but they do not. The sum of all the first columns is
| 19,220. The sum by adding the row totals is 19,246. There is a difference
| of 26 and can not see any different numbers being calculated. I can send the
| sheet to someone if you like.