This might seem a silly question, but are you adding (with the
calculator) the numbers with the decimals or as whole numbers?
Next thing, if you highlight the column of numbers with the cursor and
check the sum that you will see in the bottom right hand sde of the
spreadsheet, is it the same as the total you get with the Sum(x:y)
statement?
Next: Is the format of all the cells in the resutls column the same -
are you rounding up, down or off - Set them all to the same rounding
and things should start looking better

Cheers


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=393260