Hi Everyone,

I have the Following Formula ( Posted by Bernd ) that Adds the Digits in
a Single Cell Together to give a Total. For Example if Cell "A1" had
123456789 the Formula would Return the Answer 45.
Is there Anyway to Adapt the Following Formula ( which is Array Entered
) :-

=SUM(VALUE(MID(A10,ROW(A1:OFFSET(A1,LEN(A10)-1,0)),1)))

So if I had the Following Data in Cells :-

A10 = 9
B10 = 13
C10 = 20
D10 = 32
E10 = 41
F10 = 46

It Adds the Digits Together 9+1+3+2+0+3+2+4+1+4+6 and gives the Total
35.
I know that I Could Concatenate A10:F10 and then Apply the Formula, But
it would be Nice if it Could be Done Within One Formula.
It is Basically the Sum of ALL Digits ( NOT Cell Values ) from A10:F10.
Is there Also a Macro Available that will do this Please.

Thanks in Advance.
All the Best
Paul




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!