Adding Cells that Contain Text

D

derr04

Is there anyway that I can add two cells ie.

cell 1 - (5 - Oranges)
cell 2 - (6 - Grapes)


and get a sum of 11 in the third cell...i cant just use the sum
function because of the text being in the cells
 
S

Soundar

Hi,

You can use the sum function as follows to solve your problem:

=SUM((VALUE(LEFT(A1,1))),VALUE(LEFT(A2,1)))

cell a1 --> 5 - oranges
cell a2 --> 6 - Grapes

so that you will get 11 as result.

Hope this will clear your doubt.

Regards,
Soundar.
 
K

Kevin B

This would work, as long as there's a space between the value on the left and
the hyphen:

=VALUE(LEFT(A1,FIND(" ",A1,1)))+VALUE(LEFT(A2,FIND(" ",A2,1)))
 
Top