Using a string function within a range in SUMIF -- possible?

Is it possible to use SumIf with a string function in the range? Example is if I have these columns and I also have it attached in Excel:

001 - Total Cat1 12
001 - Total Cat2 43
001 - Total Cat3 44
002 - Total Cat1 43
002 - Total Cat2 66
002 - Total Cat3 89
003 - Total Cat1 23
003 - Total Cat2 11
003 - Total Cat3 23

Total Cat1 78
Total Cat2 120
Total Cat3 156

I'd need to do a Right string function on Column A to only compare the Right 10 characters but I'm not able to find a way to do this. Can this be done in the SUMIF Criteria Range without having to create a new column just to contain this info?

Thanks --