Using Wildcards within formula

[karstens]

I am currently using the following formula thanks to a wonderful helper on this forum:

=SUMPRODUCT(--('Trial Balance'!A1:A100="6120"),--(ISNUMBER(MATCH('Trial Balance'!B1:B100,{"00.00.01","00.01.01"},0))),'Trial Balance'!G1:G100)

Is there a way to use this formula, but instead of looking in Column B, and having to list 00.00.01, 00.01.01, that it only looks at the last two digits of the ##.##.##.

Here is the issue. Each month, the numbers that make up what I need to add together will change. However, all I am really doing, is combining any accounts that have the same sub account (Column B) ending in the same digits of either 00, 01, 02, or 08. So I could have 01.01.01, 01.00.01, 01.02.01, etc. and I am just focusing on the .01 on the end. I would like to say, look at all the sub accounts in B, and only add (G:G) on those that the last two digits equal .01.

Is this possible? Or did I make no sense at all?

[squiggler47]

How about :-

=SUMPRODUCT(('Trial Balance'!A1:A100="6120")*(RIGHT('Trial Balance'!B1:B100,2)="01"),'Trial Balance'!G1:G100)

[karstens]

SWEET! That worked PERFECTLY!
Thank you so much. Have an awesome weekend!