Formula to Sum 3 Column Values based on Multiple Criteria for Multiple Rows

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

Can you provide a sample file to see what we are working with?

I can't make the document small enough to upload it here, the maximum size is 1 mb. Is there anyway around this?

I don't need to see the whole data set. Just a small sample of the data. And if you can include expected results by manually typing them in and highlighting the cell.

If you remove most of the data the file size should get smaller.

I barely had any data on it, 8000+ rows went to 15 and the other sheet was like 3x3 with data. Still 2x too large. Is there a different file format I can send it as?