View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] derr04@gmail.com is offline
external usenet poster
 
Posts: 13
Default Adding Cells that Contain Text

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