Average and lookup column values

[JaoMagbanua]

Hi

I need to find the average of data in columns based on two criteria. Column a has names,b has subjects and c has grades. there are multiple instances for pairs of names and subjects. I need to find the average of those pairs. I have attached a file for reference

Average
Jon English ?
Mat English ?
Jon Math ?
Mat Math ?
Jon Science ?
Mat Science ?

Jon English 4.46%
Jon English 1.74%
Mat English 12.44%
Jon English 4.78%
Jon Math 2.23%
Jon Math 28.97%
Mat Math -
Jon Math 1.33%
Jon Math 9.97%
Mat Math 0.00%
Jon Math 5.74%
Jon Math 2.23%
Jon Math 0.00%
Jon Math 6.14%
Jon Math 0.00%
Jon Math 2.69%
Jon Science 9.73%
Mat Science 2.61%
Mat Science 7.39%
Mat Science 7.59%
Jon Science 2.16%
Jon Science -
Jon Science 7.76%
Mat Science 13.46%

[etaf]

Averageifs()
=AVERAGEIFS($C$1:$C$24,$A$1:$A$24,F2,$B$1:$B$24,G2)

[JaoMagbanua]

Averageifs()
=AVERAGEIFS($C$1:$C$24,$A$1:$A$24,F2,$B$1:$B$24,G2)

Thank you! I have just figured it and you confirmed. SO grateful for your prompt response.

[etaf]

you are welcome

[wk9128]

For DYNAMIC formula

H2 formula