使用IF语句的Excel数组公式

I am not that great with array formulas in excel so I thought maybe someone in this community might be able help me. I have data in two seperate worksheets and am trying to sum the information for given parameters. The first worksheet looks like so I am not that great with array formulas in exce