Average If array with mutliple criteria for one column and criteria from another column

Hello,

I am having a hard time getting a formula that will compute something that seems rather simple to me.

Basically I would like an formula that will average a set of numbers for multiple criteria(for this example, days) from one range in addition to criteria from another range(position). Here is the formula I have been using that I thought would work well. This example refers to J18 in the attached workbook.

=AVERAGE(IF((G2:G374=J3)+(H2:H374=J4)+(H2:H374=J5),F2:F374))

J3 is one of the criteria(Skill, Mid, or big)
J4 and j5 are criteria from the same range(Tue and Thu)
F2:f374 is the range of data I want to average corresponding to J3, J4, and J5

It is my understanding an averageifs will not work because it will not do multiple criteria in the same column.

I have manually averaged some of the formulas to double check them and they are not computing accurately. I feel like I am missing something simple or easy that is not locking in the specific data I would like to compute. I would really appreciate it if someone could help me get this problem resolved. Thanks for your time.

Try this ...

=AVERAGE(IF((G2:G374=J3)*((H2:H374=J4)+(H2:H374=J5)),F2:F374))

Array formula.

Thanks the help. It still doesn't seem to be calculating right. Can't understand what the issue could be