Excel How to add numbers in same cell?

N

Nurshakinah

Joined
Sep 24, 2019
Messages
1
Reaction score
0
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..
 
Nurshakinah said:
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..
Click to expand...
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))
 
Last edited:
Back
Top