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