Numbers

B

Boenerge

Is there a formula that would add numbers together within a group of cells
and ignore the text e.g. (col a row 1) LDS12 (col b row 6) L9 (col c row 5) S7
returning the sum of 28?
 
D

Don Guillett

One way is to use this idea for each +
=MID(A4,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A4&"0123456789")),99)*1
Another is a macro
 
Top