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

[samalex]

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

[samalex]

Actually I just found that I can use wildcards in the criteria parameter so this works:
=SUMIF(A2:A10,"*Total Cat1",B2:B10)

So consider this solved.

[NBVC]

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[scottylad2]

=SUMPRODUCT(--ISNUMBER(FIND(A12,$A$2:$A$10)),$B$2:$B$10) on your sample yeilds the same result as you have

[ChemistB]

Helpful hint, using references so you can drag it.

=SUMIF($A$2:$A$10,"*"&A12,$B$2:$B$10)