Under multiple conditions of repeated data and count the number of data as required

Newcomers ask for help. When doing statistics, there are two places a little confused

One class of 1 mathematics and 1 class of 2 mathematics can be counted as 2 classes. The same subject in
different periods can be counted as one data value. Find the data value of the overall subject class

Class 1 and class 1 are all in the same class, so they are in the same class satisfaction value, which can
only be calculated once in the statistics, find the overall subject satisfaction number

I especially highlighted it in orange, which is what I want

Can someone please help me ? It would be much appreciated. Thanks in advance

with count if to get 1 criteria.

with vlookup in a table.

after that a pivot table.

see the attached file.