Formula to explain

  • Thread starter Thread starter Sushil
  • Start date Start date
S

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.
 
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.
Click to expand...

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
 
Back
Top