Excel How to add numbers in same cell?

[Nurshakinah]

Hi,

I have a problem in excel.. I need to add numbers in the same cell.. For example, i have 27 so i want to add 2+7=9.. And this 27 is the sum from another cells( i use formula =sum(num1, num2..))

Do anyone have any idea? I really need this.. Thanks in advance..

 

[Terry James]

Can you attach an example of an Excel worksheet showing the calculation.

 

[AmjiBhai]

Hi,

I have a problem in excel.. I need to add numbers in the same cell.. For example, i have 27 so i want to add 2+7=9.. And this 27 is the sum from another cells( i use formula =sum(num1, num2..))

Do anyone have any idea? I really need this.. Thanks in advance..

the sum total of F3 to F6 =27 in F7
now let's replace value of F7 with the following formula...this will give you 9...

=IF(LEN(SUM(F3:F6))<>2,"err",(LEFT(SUM(F3:F6),1)*1)+(RIGHT(SUM(F3:F6),1)*1))