View Single Post
Old May 8 2013, 05:03 AM   #4
Asbo Zaprudder
Rear Admiral
 
Asbo Zaprudder's Avatar
 
Location: Magic realism
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.
__________________
"Sans le canard de Vaucanson vous n'auriez rien qui fit ressouvenir de la gloire de la France." -- Voltaire -- Flip flap!
Asbo Zaprudder is online now   Reply With Quote