Compare two tables and have an output

[yatari]

Hi ,
I'm fairly new to formulas and I want to compare two tables and have specific output
Example:
formula.PNG

At the right I just want to have how many are yes and no for specific color.
I've have tried with countif formula , but it's adding all counts for each color. Instead of matching how many are for red,blue,etc..
Any help would be appreciated.

[AliGW]

Try COUNTIFS instead:

=COUNTIFS(criteria_range_1,criteria_1,criteria_range_2,criteria_2)

So, something like:

=COUNTIFS($B$4:$B$12,$E4,$C$4:$C$12,F$3)

[yatari]

You're awesome!!!!
That's the formula that I was looking for!

Thank you!

[AliGW]

And you're welcome!