How to sum the numbers in a single cell..

[brucekeif]

I wanted to know if there is the possibility to create a formula that will sum the numbers in a single cell. i.e If i have a cell with 27 it should return 9 summing 2+7 or if i had a 51 it would return a 6

Also if possible should i have a 2 it should return a 2 and should i have a 123 it should return a 6

I am not an advanced user of excel so please make the formula as uncomplicated as possible.
Thanks very much for your help.

Bruce

[:) Sixthsense :)]

In A1 cell
123

In B1 cell - Array Formula Requires Ctrl+Shift+Enter

Please Login or Register  to view this content.

[PRADEEPB270]

Suppose your data is in A1 cell i.e.27.

Then apply the formula-
A1-FLOOR(A1-1,9)

[brucekeif]

Thanks. I am trying it but it keeps coming back with 16..Also this is what i need to do.

a b
1346 sum of this
1457 sum
5684 sum
3462 sum

Hope this makes it easier to understand. thanks a lot.

[brucekeif]

thanks. Can you tell me "exactly" what i would need to put in the B cell for this number in the A1 cell 6842 using your formula below..Do I need the = sign also in front of it. (told you I was not advanced)

A1-FLOOR(A1-1,9)

[PRADEEPB270]

Suppose your data is in A1 cell i.e.6842.

You may apply the formula either = or with +,as below:-

=A1-FLOOR(A1-1,9)
OR
+A1-FLOOR(A1-1,9)

Hope,it is easy to understand.

[brucekeif]

yes. it is working now. Thanks. I am a numerologist. Here is my ultimate goal.

ex..Birthday is 8/9/1967 = sum then need to use your formula to break down to single digit. However if
the sum equals to a 11 22 or 33 it would not break down to the 2 the 4 or the 6. Can you help?? You
have been terrific in instructing me.