Wednesday, February 22, 2012

Array Formula ( sum of digit in a cell)


Sum of Digit from a cell.
Many time we need sum of Digit which are placed in a single cell, we can use this function to get desired result

=SUM(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))
As CSE (Ctrl+Shift+Enter)

No comments: