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?

sum with text in cell
 

Maybe something like this:

With values like you described (a number followed by spaces followed by
letters) in A1:A10.

The total of the leading numbers:
A11: =SUMPRODUCT(--LEFT(A1:A10&"0 ",SEARCH(" ",A1:A10&"0 ")))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

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?