If you have a cell that contains a value (number), you may want to devise a way to add together all the digits in the value.

I can’t imagine a situation where this would be necessary, but I’ve seen a version of this question asked on so many different occasions, I thought that I would be helpful and post my solution to this question here.

If you have a cell that contains a value (number), you may want to devise a way to add together all the digits in the value.

For instance, if a cell contains the value “765”, you might want to determine the sum of 7+6+5, which is 18.

The simplest way that I know of is to use one formula that relies on several functions.

Assuming the number is in cell “A1”, the formula would be:

=SUMPRODUCT(–MID(A1,ROW(INDIRECT(“1:” & LEN(A1))),1))

This regular formula will sum the digits in any integer value (in cell A1) in a simplistic manner.