Don't both, add directly

=SUMPRODUCT(INT(A1:A2))

=SUMPRODUCT(MOD(A1:A2,1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"yodochi" wrote in message
...
hi, how do i split dollars and cent in 2 colums and at the end sum it,
for example: A1 Dollar, B1 cents, A2 dollar, B2 cents and in A3 and B3
the sum result of A1,A2 and B1 B2.
thanks for help