Text and Numbers sum in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Sue,

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

Mike
 

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

finding the number of occurences 2
Fomulas with tex and numbers in same cell 2
LOOOONG if statement out of room, need help to shorten 4
Need a count formula 1
Macro to add numbers in a text string 5
Parsing text file 0
Help with IF - THEN 5
need info to display only after date is current and stay there 4

Back
Top