hey u r really good , this is what work and do the job, i apreciate your
kindness in helping out



"David Biddulph" wrote:

But if you want Ron's result split between A3 & B3 as requested, then
A3 =INT(SUM(B1:B2)/100+SUM(A1:A2))
B3 =MOD(SUM(B1:B2)+100*SUM(A1:A2),100)

The most obvious problem with that is if you have fractions of cents & these
try to round up values greater than 99.5 to display as 100 cents. In that
case you may need to do rounding in the formulae.
--
David Biddulph

"Ron Rosenfeld" wrote in message
...
On Mon, 13 Aug 2007 05:32:02 -0700, yodochi

wrote:

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


=SUM(B1:B2)/100+SUM(A1:A2)


--ron