Agreed it works, but this, along with the Microsoft suggestion, is volatile. Would there be a reason to use this over the apparently non-volatile suggestion of DonkeyOte?Sum digits (more than one) of a number
=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))
Regards