Colum 1 = Text Account numbers (ie..."1022")

Colum2 = Dollar Amounts

I need a formula to say

if colum 1 has text numbers xxx OR xxx OR xxx (there could be a lot of xxx's) then add all the amounts associated with those numbers

I thought I could do it with: =SUMIF(B6:B1002,"1022",F6:H14) , however, I

need to add more text account numbers ("1022") and this is where I am stumped!

Thankfully someone helped me with the following formula that has changed my life....

=SUMPRODUCT(--ISNUMBER(MATCH($B$1:$B$1502,{1022},0)),$C$1:$C$1502)

I would like to add a second ISNUMBER to the formula, but don't want to screw it up....so it will say...if there is a match in the first and second colums, then all the amounts associated with those numbers.

Any help would be appreciated again!!

Thank you