The RIGHT function returns text, which is ignored by the SUM function. Change
formula in column C to:

=MOD(B1,10)

to return the value of the one's digit.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"april" wrote:

Column A Column B Column C
numbers =round(a1,0) =right(B1,1)

the numbers in Column C won't add. i keep getting -0-

thanks for your help
--
aprilshowers