Adding numbers in columns with letters

A

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
 
M

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)
 
B

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
 
Top