View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default sum with text in cell

hello,

I am trying to do a sum on a group of cells that have a range between 3
and 10.5 the cells are as follows.

3 HP
3 HDP
3 SP
3 HSP

I would like to create a sum so that it would equel 12 or the equivlant
there in. the text needs to show as it is important. and they need to
be in the same cell. is this possible?