Summing the digits of a number is a chore I’ve been doing alot lately. Originally I’d parse the number out over the columns. And since SUM() ignores text, I’d turn the characters into digits by applying an arithmatic identity operation, like this: =- -MID($A10,COLUMN(),1) That’s double minus signs before the MID() function. The reasons [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/10/03/summing-the-digits-of-a-number/
Posted
Oct 03 2009, 05:01 PM
by
Daily Dose of Excel