return one value with multiple criteria in different rows & columns

Question

I need help creating a formula that returns one value with multiple criteria in different rows & columns.

For example, I want to return the November Hours for the Parent, John's child, Phil.

I need to be able to match John and Phil (in two columns) to November Hours (a row) to return a value within the array of D4:G9. The correct answer would be 4, but every time I try a traditional INDEX(MATCH), I get an N/A.

I attached a picture of my sample data.

Answer 1

With Column B filled in as the comments suggest:

=SUMIFS(INDEX(D:G,0,MATCH("November Hours",$D$2:$G$2,0)),B:B,"John",C:C,"Phil")