IF ARRAY Formula

I am trying to find the SUM of a multi part IF statement using a separate spreadsheet:

=SUM(IF(AND([Doc.xlsx]Sheet1!$B$7:$B$348="APPL*", C15=[Doc.xlsx]Sheet1!$C$4:$BG$4),[Doc.xlsx]Sheet1!$I$7:$J$348))

NOTE: C15 = A1

I've tried breaking this formula down into these two separate parts:

=IF(C15=[Doc.xlsx]Sheet1!$A$4:$BG$4,TRUE)

and

=IF([Doc.xlsx]Sheet1!$B$7:$B$348 = "APPL*",TRUE)

However, these all fail out.

How can you find a single output using two criteria such as a column head and a row header?

Here is an image of what I'm working with. I need to sum all of the numbers met by the criteria from the grid by using the Column header and Row header. Doc.xlsx