Pull Data Based on Multiple Criteria

[JasmineL]

Hi all!

I'm trying to pull data from a range if multiple criteria are met. I have done this with SUMIFS in the following formula:
=SUM(SUMIFS('[PRODUCTION - 2017.xlsx]Data-17'!$RD:$RD,'[PRODUCTION - 2017.xlsx]Data-17'!$D:$D,N6,'[PRODUCTION - 2017.xlsx]Data-17'!$I:$I,{10,11,12,""},'[PRODUCTION - 2017.xlsx]Data-17'!$J:$J,{"2016";"2017"}))

I thought I could just try using IFS, but it didn't work.

Essentially, I want my formula in the new worksheet to go out to the existing worksheet and look for {"2016","2017"} in column J and look for {2,3,4,5,6,7,8,9,10,11,12,""} in column I. If both these criteria are matched in the existing worksheet, pull back the contents from the matching cells in columns A,B,C into the new worksheet.

I could manually do this each month by filtering the existing worksheet by column J for 2016 and 2017 and column I for 2,3,4,5,6,7,8,9,10,11,12,"" and then copy and paste the filtered results from columns A,B,C, but I was hoping to avoid this manual step.

Any suggestions would be appreciated greatly.

Jasmine