Although VB is quite good at anticipating variable conversions it can be smarter to explcitly defien the data type you want
if you are using integers
csng for single precision
cdbl for double precision
suspect in your case it would be best to use csng, you can mix and match
the sum would work, i think if you were using in a report or form group footer where you wanted the sum of the values in the group.