Adding cell values based on what you see

[Jeff Jacobson]

Change your formula that rounds the numbers to =VALUE(ROUND
(A1,0)). Then simply sum these values. If you do not
have a formula rounding these numbers, just add a formula
=VALUE(A1) referencing each rounded value. Then sum these
values.