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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare two different workbook sheet to show the difference in text 0
How to get the count and average of values in reference to anotherrange of data 3
sumif to add more than one column of cells. 4
Lookup formula help 4
Excel VBA Macro to do this? 19
automatically numbering rows 2
Macro for comparing columns and highlighting matching/differences 13
Looping problem 2

Top