Excel Forum

Excel Magic Trick 305: SUM digits from string

See how to put 112.1 in a cell and add the digits = 1+1+2+1 = 5 using the SUMPRIDUCT, MID, ROW, INDIRECT and LEN functions in one formula.

Mr Excel mrexcel Message Board

Got a Question? Ask it Here in the Forum.