Are there maybe a formula to add the individual numbers in a value together?
ie 10875 = 1+0+8+7+5 = 21
The only I can think of is writing VBA to change to text, split it up with Data text to columns and then changing back to numbers and then @sum. The range of values to do is from 1 to 20 000 000.
Thanks
Mario