Thread
:
Help with Similar MOD Function Please
View Single Post
#
9
Posted to microsoft.public.excel.programming
Paul Black
external usenet poster
Posts: 394
Help with Similar MOD Function Please
Has Anybody got Any Ideas on How to Solve this Please.
All the Best
Paul
(Paul Black) wrote in message m...
It's Me Again,
Is there Anyway to Adapt the Formula ( Array Entered ) :-
=SUM(VALUE(MID(A10,ROW(A1:OFFSET(A1,LEN(A10)-1,0)),1)))
So if I had :-
A10 = 9
B10 = 13
C10 = 20
D10 = 32
E10 = 41
F10 = 46
it would Still Work.
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 Individual Digits from A10:F10.
Thanks Again.
All the Best
Paul
Reply With Quote
Paul Black
View Public Profile
Find all posts by Paul Black