Formula to explain

[Sushil]

Can any one please explain this:

=SUM(MID(0&D19,LARGE(IF(ISNUMBER(MID(0&D19,ROW($1:$256),
1)*1),ROW($1:$256),1),ROW($1:$256)),1)*1)*10^(ROW($1:$256)-1)

Though it was put in and explained by my manager, but I don't
remember.


Thanks in advance.

 

[James Ravenswood]

Can any one please explain this:

=SUM(MID(0&D19,LARGE(IF(ISNUMBER(MID(0&D19,ROW($1:$256),
1)*1),ROW($1:$256),1),ROW($1:$256)),1)*1)*10^(ROW($1:$256)-1)

Though it was put in and explained by my manager, but I don't
remember.

Thanks in advance.

If you enter the formula as an array formula, using CNTRL-SHFT-ENTER
rather than just the ENTER key, the formula returns the sum of the
digits in cell D19. For example if D19 contains:
123abcde10

the formula will return 7