Adding numbers in columns with letters

[Arrow]

I need a little help. How do you add up the values of numbers in
column which has letters next to the numbers. I have a column o
numbers, but the letters "mb" are a space bar away from the numbers.
Everytime I use the function to add the numbers I get a value of zero.
Could anyone please help me out? Thanks in advance

 

[Myrna Larson]

Assuming you mean the "numbers" all end with " mb", e.g. "123 mb", you can add
a "Helper" column containing a formula like this:

=--LEFT(A1,LEN(A1)-3)

Copy down as far as needed and sum that column.

If the letters are on the left, i.e. "mb 123", the formula is

=--MID(A1,4,255)

 

[Bi9ff]

Hi Arrow!

If you data looks like this:

102 mb
10 mb
22 mb
10 mb

=SUMPRODUCT(--(LEFT(J2:J5,LEN(J2:J5)-3)))

Biff