Using Subtotal to calculate AVERGEIF, MAXIFS and MINIFS on filtered dataset

Hello 

I am working with a huge dataset of almost .5 million records and need to update the AVERAGE, MIN and MAX values for the MATCH SCORE field for each user as the data set is filtered.

The dataset contains multiple records for each user pair
AUsers are in COL A
BUsers are in COLB
matchScore range is in COL C
COL E holds the list of unique users against which the calculations are performed using AVERGEIF, MAXIFS and MINIFS

Average for each user:

Formula:

=IF(ISERROR(AVERAGEIF(AUsers,E2,matchScore)),0,AVERAGEIF(AUsers,E2,matchScore))

--- the ISERROR is used to avoid the #DIV/0! error
MAX for each user:

Formula:

=MAXIFS(matchScore,AUsers,E2)

MIN for each user:

Formula:

=MINIFS(matchScore,AUsers,E2)

I need help updating the formulas above with the SUBTOTAL function so that the formula results update as the user list is filtered.

I tried the following formula in H2 to find the AVERAGE but I am getting the average of all Scores and not for just the user in COL E

Formula:

=AVERAGE(IF(SUBTOTAL(9,OFFSET(C2,ROW(C2:C21)-ROW(C2),0,1))>0,C2:C21))

I appreciate any help you can provide!

Thanks so much,
Sandra