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

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

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

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

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