excell formula 9+5=4 not 14
 

want excell forumla to show 1-9 totals in sum answer, not 10,11,12,15,19,etc.

Assuming the source numbers are in cols A and B, row1 down

Try in say, C1:

=MOD(SUM(A1:B1),10)

Copy C1 down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"tyler94" wrote in message
...
want excell forumla to show 1-9 totals in sum answer, not
10,11,12,15,19,etc.