Add numbers within a cell

maa564 · May 17th 2005

Hi

I need to add numbers within a cell. for example...one of the cells is a total of a range of cells..say total is 43...now I need to add 4 + 3 and display the results (7) in another cell.

The book that describes this calculation has refered to it as cross-addition and/or laterally add numbers.

Thanks for your help in advance.

Philkwok · May 17th 2005

Re: Add numbers within a cell

Hi,

See if this can help your temporary ... believe there should be a simpler method.

=IF(LEN(B8)>2,(LEFT(B8-ROUNDDOWN(B8,-2))+RIGHT(B8-ROUNDDOWN(B8,-2))+LEFT(B8)),(LEFT(B8)+RIGHT(B8)))

Cheers.

Kieran · May 17th 2005

Re: Add numbers within a cell

maa564,

look at Bob Umlas under the heading Calculating The Sum Of The Digits.

maa564 · May 17th 2005

Re: Add numbers within a cell

thanks Kieran. Bob's page was solved my problem so easily...and gave me some more ideas as well
thanks once again.

Add numbers within a cell

Participate now!

Share