COUNT Games Played

Good day to everyone! So, this will be my 1st post here is please bare with me.

Anyhow, I need your help. I am currently working on games stats. Apparently, I am having trouble with one thing. Here is my worksheet:

excel.png

Here's what I want to do:

1. I want to come up with a formula that can count how many games a certain player played. For instance: I want to appear on E2 how many times Drew played any game (which is in A2:A12).

2. I want to come up with a formula that can count how many times a player chose a certain game. For instance: I want to appear on E3 how many times Juls played Game 3(which is in A2:A12).

Another one:

excel2.png

3. I want to come up with a formula that would rank entries automatically. As you can see on the picture, I want to rank the entries from column F based from the numbers on column G. However I want it ranked on column B (for Column F) and column C (for Column G). Is this possible?


I am really looking forward for everyone's help!