Adding Cells that Contain Text

  • Thread starter Thread starter derr04
  • Start date Start date
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
 
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.
 
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)))
 
Back
Top