Average filtered funtion based on Multiple Criteria

[krist01]

Issue	Par Status	Turn Around Time	Date Recieved
Claims	Par	3
MNR	Non-Par	5
Claims	Par	2
MNR	Par	1
Claims	Non-Par	3

<tbody>
</tbody>

The above table depicts my columns, I need a formula that will allow me to view the average turn around times for Claims that the Par status equals "Par" when filtered by the user... typically filtered by quarter or month. I have formulas that work for one criteria, not sure how to do multiple.

 

[NeonRedSharpie]

The above table depicts my columns, I need a formula that will allow me to view the average turn around times for Claims that the Par status equals "Par" when filtered by the user... typically filtered by quarter or month. I have formulas that work for one criteria, not sure how to do multiple.

What are your formulas that work for one criteria so we can help modify them?

 

[krist01]

The formula I located online that works for filtered views is

=SUMPRODUCT(SUBTOTAL(3,OFFSET('Live Data'!M2:M200,ROW('Live Data'!M2:M200)-MIN(ROW('Live Data'!M2:M200)),,1)), --('Live Data'!M2:M200=A6))

it is my understanding that we simply change the function from 3 to 1 to average the column... but not sure how to include additional parameters...