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...
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...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...

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.