Sum formula when cell cantains alphabets too

D

d3graph

Joined
Oct 25, 2009
Messages
1
Reaction score
0
hi there

i am looking for a Sum formula when cell contains alphabets too

sample data

70 meters 71 meters 72 meters 73 meters 74 meters 75 meters 76 meters 77 meters 78 meters 79 meters 80 meters 81 meters

this data is entered in same column and one cell contains like 75 mtrs

please help
 

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

Calculate Stanine Values 6
Count and Sum Total occurrances of two specific numbers 10
How Do I Query a Named Range 2
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria 2
Rank and Sort 4
Match Last Occurrence of two numbers and Return Date 6
Match Last Occurrence of two numbers and Count to Previous Occurence 31
Transpose Macro 1

Top