Adding figures within a cell

[Tojje]

I have a problem I can not solve.

I have a lot of cells containing figures and I need to find an east way to add the figures witin a cell. i.e 123456 would result in the sum of 21.

Appreciate a fast and relevant answer.
Thanks a lot
/JE

[giacomo]

are your figures always less than 10? In other words, how can you tell 1+2+3+4+5+6 from 12+34+56?

giacomo

[Asala42]

G'day,

Here's J.Walk's array formula for summing digits in a positive integer:

={SUM(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)*1)}

(hit Ctrl+shift+Enter to get the brackets)

Adam

[Tojje]

On 2002-05-15 10:29, Tojje wrote:
I have a problem I can not solve.

I have a lot of cells containing figures and I need to find an east way to add the figures witin a cell. i.e 123456 would result in the sum of 21.

Appreciate a fast and relevant answer.
Thanks a lot
/JE

[Tojje]

Thanks for your fast relies !

First thing is that I do not need to seperate 123456 from 12+45+89 due to th efact that I have figures wich are partnumbers and I need to add together each separate figure in that productcode to get a sum. When I have done such its possible for me to continue with this project regarding barcode labelling calculations. So a partnumber could look like 74914440300 The sum of that is 36 etc.

Regarding the formula sent as well please adopt that with the above partnumber so I get a feel for how to use it.

Thanks again for your support with this.
Hope to hear from you soon
Thanks
/JE

[klb]

Shouldn't the final answer be 3 and not 21?

[Chris Davison]

On 2002-05-15 13:05, Tojje wrote:
Regarding the formula sent as well please adopt that with the above partnumber so I get a feel for how to use it.

pop your part number in cell A2, then in another cell type the formula, entering it when finished with CNTRL and SHIFT and ENTER all at the same time

if you can't use cell A2, then change the "A2" bit in the formula to wherever your partnumber is

[Tojje]

WHen it comes to building formulas I have to admit my novice knowledge.

I can not get the formula to work according to your advice.

I put a partnumber in cell A2, just to make sure I didi not chnage anything in the formula. The partnumber was 74914440300.
I typed in the formula exactly as you intrióduced it but when hitting Ctrl+SHIFT+ENTER I get an error message saying "error in formula" The SUM part of the formula is highlighted.

I can´t get it right !
Could anyone please use the mentioned partnumber and try to use the formula with it ?

DO you get the same error message ?

Appreciate all your help !
Regards
/JE

[Tommy Bak]

Hi
If KLB is right (checksum should be 3 and not 21) this formula will do.
=IF(MOD(A1,9)=0,9,MOD(A1,9))

regards Tommy

[Tojje]

If we stay with the example 123456 the sum should be 21.(1+2+3+4+5+6 = 21)

The whole problem is to add each figure within one cell.

Thanks for your support !
/JE

On 2002-05-17 02:57, Tommy Bak wrote:
Hi
If KLB is right (checksum should be 3 and not 21) this formula will do.
=IF(MOD(A1,9)=0,9,MOD(A1,9))

regards Tommy