SUMIFS (text to number problem)

Hi all,

Hope all is well. I need some help on sumifs formula. I am trying to do a sumifs formula however I have the criteria range which is in text. Therefore the sumif formula is not working properly. Is there a possible way how I can incorporate this fact into the formula so as to convert the text to number, in order for the sumif formula to work?

Apologies, if this thread has been posted already, if yes can someone pls guide me accordingly?

I have also attached the file for reference

Thanks everyone