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?
|