Excel Forum
Similar Content
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Odd or Even Row Formulas in Excel
Tutorial: Formulas to determine if the current cell is odd or even; this allows you to perform speci...
Sum Values from Every X Number of Rows in Excel
Tutorial: Add values from every x number of rows in Excel. For instance, add together every other va...

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.