Using a cell column from another sheet in a formula

[nodejo]

Let me explain this thread title.

I have 1 sheet (named "N1") with all football results like this : HomeTeam | AwayTeam |Home Team Goals |Away Team Goals

Now I want to make a formula in a different sheet that does the following.

A list of all the teams and 3 columns after that: |Home Team games | Home Team Goals made | Home Team Conceded
Team1 |
Team2 |
Team3 |

So i need a formula that scans the Home team column on sheet "N1" and make a sum of the amount of games played at Home for that team.
Than the cell next to it I wanna sum all the goals made at home for that team (so sum the Home Team Goals Team1, etc)

Ive added the workbook because I might have not explained it very well. But this workbook will show exactly what I mean.

[maym]

Use Countif to sum the amount of games played at home:

COUNTIF('N1'!C2:C73,Dutchleague!B3)

Use SUMIF for goals:

SUMIF('N1'!C2:C73,Dutchleague!B3,'N1'!E2:E73)