convert string to float inside a SUMIF function

Question!

I'm using the SUMIF function except that the column I'm trying to sum is a string like this : "AU $12.3" instead of just "12", how can I strip this string to just return the float value inside my SUMIF statement ( in the E column ) ?

=SUMIF('may'!$D$1:$D$500,"*Amount*",'may'!$E$1:$E$500)

thanks !



Answers

You could try something like this:

=SUMPRODUCT(ISNUMBER(SEARCH("Amount",May!$D$1:$D$500))*REPLACE(May!$E$1:$E$500,1,4,0))
By : lori_m


This video can help you solving your question :)
By: admin