With
A1: (a number)

This formula sums each digit in that number
B1: =SUMPRODUCT(--MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1)),1))

Example:
A1: 123
B1 returns 6


Does that help?
------------

Regards,

Ron
Microsoft MVP (Excel)


"pchr" wrote in message
ups.com...
Hi,
Is there an easy way to arrange a formula that will Sum all integers
of a given number?

such that when applied on colum A, the result will be B:

21 3
77 14
12345 15
1 1
321 6

thanks for you help,
pchr