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.