sum with text in cell

  • Thread starter Thread starter dpb0180
  • Start date Start date
D

dpb0180

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Sum numbers in cells that also contain text 34
Sum every Nth Row (almost working) 1
XL2002 SUM with a twist... 4
#value! error in sum function 8
Sum of cells, where there are not errors in them 8
Sumif based within non blank cells 3
Summing multiple account #s in one cell, by referencing 4
SUM only Cells where there is text in Another cell 1

Back
Top