View Single Post
Old May 8 2013, 05:03 AM   #4
Asbo Zaprudder
Rear Admiral
 
Asbo Zaprudder's Avatar
 
Location: Sand in the Vaseline
Re: Microsoft Excel question

Try this instead:

=SUMPRODUCT(MID(B1,ROW(OFFSET($A$1,,,LEN(B1))),1)+ 0)

assuming the cell containing the digits that you want to sum is B1.
__________________
"After a time, you may find that having is not so pleasing a thing, after all, as wanting. It is not logical, but it is often true." -- Spock -- Flip flap!
Asbo Zaprudder is offline   Reply With Quote