| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text and Numbers sum in a formula
Does anyone know how to add rows with both text and numbers:
ct/2.5 ct/8 8 at/8 ct/12 total I want to add the total to equal 38.50 Thanks! -- Sue |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text and Numbers sum in a formula
if it is always a three character lead when there is text
try =sum(if(isnumber(range),range,value(trim(right(ran ge,len(range)-3))))) entered as an array function control-shift-enter "Sue F" wrote: Does anyone know how to add rows with both text and numbers: ct/2.5 ct/8 8 at/8 ct/12 total I want to add the total to equal 38.50 Thanks! -- Sue |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text and Numbers sum in a formula
Sue,
You could use one of the ways given to you in the same question you asked yesterday! Mike "Sue F" wrote: Does anyone know how to add rows with both text and numbers: ct/2.5 ct/8 8 at/8 ct/12 total I want to add the total to equal 38.50 Thanks! -- Sue |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text and Numbers sum in a formula
So I need to enter the range where the word range is? of say B3:b7?
-- Sue "bj" wrote: if it is always a three character lead when there is text try =sum(if(isnumber(range),range,value(trim(right(ran ge,len(range)-3))))) entered as an array function control-shift-enter "Sue F" wrote: Does anyone know how to add rows with both text and numbers: ct/2.5 ct/8 8 at/8 ct/12 total I want to add the total to equal 38.50 Thanks! -- Sue |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text and Numbers sum in a formula
yes
"Sue F" wrote: So I need to enter the range where the word range is? of say B3:b7? -- Sue "bj" wrote: if it is always a three character lead when there is text try =sum(if(isnumber(range),range,value(trim(right(ran ge,len(range)-3))))) entered as an array function control-shift-enter "Sue F" wrote: Does anyone know how to add rows with both text and numbers: ct/2.5 ct/8 8 at/8 ct/12 total I want to add the total to equal 38.50 Thanks! -- Sue |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for pulling only numbers but not text from another cell | Excel Worksheet Functions | |||
| Format Result of a Formula Combining Text & Numbers | Excel Discussion (Misc queries) | |||
| identify numbers and text differently in formula | Excel Discussion (Misc queries) | |||
| Formula for Incrementing text & numbers | Excel Discussion (Misc queries) | |||
| Display numbers only, no text formula | Excel Worksheet Functions | |||
Linear Mode
