Either you can try the formula mentioned above or you can convert the text into number in Sheet 5-Column A. By doing that, the formula which you had used, will get you result as you looking for.

Let me know if it works for you.