Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
Cell Capacity - text | Excel Discussion (Misc queries) | |||
How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions |