adding digits of a number
=SUMPRODUCT(--(MID(A11,{1,3,5,7,9,11,13},1)))
Just change {1,2,3,5,7,9,11} to each digit that you want to count
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"dantee" wrote in message
...
Hello.
Does anyone knows a function or formula that would add the digits of a
number and spit out a result?
Example.... take the number 1092836103274 (all by itself in a cell)
add the 1st, 3rd, 5th digits and so on to get 1+9+8+6+0+2+4=30
or add the 2nd, 4th, 6th digits and get the result of 0+2+3+1+3+7=16
curious
dantee.
|