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...