Need the number of rows with exact criteria from 2 columns [Closed]

Report
Posts
1
Registration date
Thursday January 21, 2016
Status
Member
Last seen
January 21, 2016
-
Hello,
I'm trying to create a formula that tells me how many rows fit the specific criteria. I have my data on my first tab. The first crucial information is in column B on the data. The second is on column M. I need my table, in another tab, to tell me how many times the specific criteria match through the entire data worksheet. I'm also constantly adding more data. So I want to be able to refresh it and the new number calculates correctly. Is this possible?

How the data is:
Blue Yes
Blue No
Blue Yes
Blue Yes
Blue No
Blue Yes
Red Yes
Red No
Red No
Red Yes
Yellow Yes
Yellow Yes
Yellow No

What I need in table on other sheet:
Blue/Yes=4
Red/Yes = 2
Yellow/Yes =2
Blue/No=2
Red/No=2
Yellow/No=1

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!