Apologies for the difficult to comprehend title/post.

I basically have one spreadsheet in Excel (spreadsheet x) with 8,000+ rows of data and approximately 30 columns. In another spreadsheet (spreadsheet y) I have about 30 rows each needing data from that original spreadsheet (x). Each row in that new spreadsheet (y) has a specific "territory ID" and those territory ID's are spread throughout that original spreadsheet (x).

I can filter the data in spreadsheet x to show me the data that fit these certain criteria (there are 3 total criteria that must be met) but I want the data to be able to move in case additional cases are added to spreadsheet x and not have to copy or manually change anything each time data is added.

Is there a way to create a formula in Spreadsheet Y that filters the data in Spreadsheet X and can also sum up those 3 columns down 8,000+ rows IF the row in X meets those 3 criteria I'm looking for?

Ex. if Criteria A, B, C are true then add column 11, 12 and 13 for row 1 all the way through 8,000+

Terribly confusing when I read it back, please do not hesitate to ask me additional questions!

Thank you,

- Rick