convert string to float inside a SUMIF function


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 ) ?


thanks !


You could try something like this:

By : lori_m

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