Text and Numbers sum in a formula

S

Sue F

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!
 
B

bj

if it is always a three character lead when there is text
try
=sum(if(isnumber(range),range,value(trim(right(range,len(range)-3)))))
entered as an array function control-shift-enter
 
M

Mike H

Sue,

You could use one of the ways given to you in the same question you asked
yesterday!

Mike
 
Top