Averageifs statement only averaging last 5 %'s

[MIRPAX]

I am trying to find a way to average the last 5 entries based on the below criteria:
Column A - Name
Column B - Function
Column C - Quality %

So, I want to averageifs(C:C,A:A,"bob",B:B,"testing"), but I only want to consider the last five entries. I also want to exclude blanks.

I have tried something like this, but it is not working:
=AVERAGEIFS(INDEX(C:C,MATCH(9.99999999999999E+307,C:C)-5):INDEX(C:C,MATCH(9.99999999999999E+307,C:C)),A:A,"BOB",B:B,"Testing")
I get a value error.

 

[Aladin Akyurek]

Define Lrow in Name Manager as referring to:

=MATCH(9.99999999999999E+307,Sheet1!$C:$C)

Define name as referring to:

=Sheet1!$A$2:INDEX(Sheet1!$A:$A,Lrow)

Define function as referring to:

=Sheet1!$B$2:INDEX(Sheet1!$B:$B,Lrow)

Define quality as referring to:

=Sheet1!$C$2:INDEX(Sheet1!$C:$C,Lrow)

Adjust the sheet name to suit in the above definitions.

For the conditional average...

Control+shift+enter, not just enter:

=AVERAGE(IF(ROW(quality)>=LARGE(IF(name="bob",IF(function="testing",IF(ISNUMBER(1/quality),ROW(quality)))),MIN(5,SUM(IF(name="bob",IF(ISNUMBER(1/quality),1))))),IF(name="bob",IF(function="testing",IF(ISNUMBER(1/quality),quality)))))