Sum Multiple criteria within a single criteria range

[tsbbranch]

I am using a SUMIFs formula to total data with two sets ofcriteria. I would like to sum multipleaccount numbers within Criteria Range 2 rather than a single account. Is there a formula I can insert into mycalculation that can sum these figures within the SUMIFS formula?
SumRange (Amount)
Criteria Range 1 (Location Names)
Criteria 1 (Location Name)
Criteria Range 2 (Account Numbers)
Criteria Range 2 (Account Number)
=SUMIFS(May17TB!G3:G1194,May17TB!A3:A1194,'BUSummary'!A11,May17TB!E3:E1194,G8)
G8 = 50000 (account number)
I would like to sum multiple account numbers within theresult (50000,61500, 62000, 63000, 64500, 65000, 66000, 69000, 7000, 7999).

 

[Tetra201]

Try this:

=SUMPRODUCT(SUMIFS(May17TB!G3:G1194,May17TB!A3:A1194,BUSummary!A11,May17TB!E3:E1194,{50000,61500,62000,63000,64500,65000,66000,69000,7000,7999}))

 

[tsbbranch]

Super Cool, thank you Tetra!!!! I worked like a charm! Thanks for furthering my educational Excel experience. No I do not have to add additional columns and categories to obtain the same information Appreciate your help very much!!!