ExcelPowerUser
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment