Add value to cell if condition is meet

I have a sheet with columns and rows like this example:

|   COLOUR   |   TO COLOR   |   DONE   |
 Red          Green          YES
 Blue         Yellow         YES 
 Yellow       Red            YES
 Blue         Green          NO

And another one with this structure:

|   COLOUR   |   OUT   |   IN    |

What I want to do, on the second sheet, every time a row is generated in the first sheet, I want to calculate for every colour how many went out and how many went in.

So, with that example, the second sheet looks like this:

|   COLOUR   |   OUT   |   IN    |  
 Red          1         1
 Blue         1         0
 Yellow       1         1

This is what happend:

1. Row 1: it was red and turn green so in the second sheet, in the row of red I need to add 1 to OUT
2. Row 2: it was blue and turn yellow so in the second sheet, in the row of blue I need to add 1 to OUT
3. Row 3: it was yellow and turn red so in the second sheet, in the row of yellow I need to add 1 to OUT and in the row of red I need to add 1 to IN

This happend with the rows who in the column of DONE is YES. For example, the fourth row is NO so I don't need to calculate this row.

How I can do this? I was trying with IF but I don't know how to use formulas in Google-Sheets.