Here's another possible option.

For those times when you don't want to put round() formulas in all your cells:
1)Set the cell formats to display an appropriate number of decimal places.
2)Sum those cells using a variation of this formula:
=SUMPRODUCT(ROUND(A1:A10,2))
That function rounds each number to 2 decimal places before it is summed.

In my example, I put =1.004 in cells A1:A10 and set the format to 2 decimal
places
Each cell displays 1.00, but actuall contains 1.004.

Using A11: =Sum(A1:A10), I get 10.04

I want my total to be 10.00 (1.00x10)
Using A11: =SUMPRODUCT(ROUND(A1:A10,2)) I get 10.00.

Does that option help?

--
Regards,
Ron