How to calculate data in Excel?

Question

excel

Greetings.
Excel is a dark forest for me when it comes to formulas.
There are two tables:

In the left one, data for each job is entered, and in the right one, summary values ​​for employees must be somehow calculated.
In the column "Passed (total)" should be the number of submitted works.
In the column "Score (average)" should be the average score for the submitted work.
I've been fiddling around for an hour, somehow it doesn't work.
Suggest a solution.

Answer 1

Strange, two days ago in your previous question you wrote:

The issue is resolved through SUMMESLI.

It's essentially the same here.
Passed (total) =ScoreIf(...)
Grade (average) =SumIf(...)/ScoreIf(...)