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.