COUNTIFS with Multiple Fields

[Excel09876]

I am currently writing up a spreadsheet for my football team to count each players games played, goals, assists, clean sheets and MOTM. I am doing this for each game and have a separate columns for each games goals, etc, as you can see in the screenshot. I am trying to do a countifs formula on another tab to count each of these individual stats for each player. Please can you give me any feedback on the easiest way to do this as I seem to have gone blank.

 

[Excel09876]

I have been doing some updates on this and now I need to add another criteria to this formula and have it include if the game is marked as "League" in row 2. What would be the best option for this?

 

[Fluff]

In that case you would need to get rid of the merged cells in row 2.
But as I have no idea what the original formula is doing (as this was almost a year ago) you would be better off starting a new thread.