numbers derived from @ right function don't add

[april]

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

 

[Luke M]

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.

 

[april]

perfect, both solutions solve the problem. thank you. also i didn't know
that @ right functions return text. --
aprilshowers