Or if you want to go over board with one formula :
=SUMPRODUCT(--MID(SUMPRODUCT(--MID(SUMPRODUCT(--MID(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),ROW(INDIRECT("1:"&LEN(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1))))),1)),ROW(INDIRECT("1:"&LEN(SUMPRODUCT(--MID(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),ROW(INDIRECT("1:"&LEN(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1))))),1))))),1)),ROW(INDIRECT("1:"&LEN(SUMPRODUCT(--MID(SUMPRODUCT(--MID(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),ROW(INDIRECT("1:"&LEN(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1))))),1)),ROW(INDIRECT("1:"&LEN(SUMPRODUCT(--MID(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),ROW(INDIRECT("1:"&LEN(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1))))),1))))),1))))),1))
Since 15x9 = 145 and excel can only display 15 digits we just need to sum the digits 3 times to ensure we have a single digit answer!
Bookmarks