Searching for number of items accepted

I have a table with data, with one column including a 'Category' e.g. A, B, C etc and another column on whether it has been accepted or not (Y/N). What I want to do is search the 'Category' column for a specific category, either A, B or C, and then search the 'Y/N' column to see if it's yes or no. I am looking to see how many yes and no's there are per category.

Thanks.

Hello,

I tried the formula but unfortunately it didn't work for me. I have also tried to attach a file, but when I click the paperclip to attach a file a small blank white box appears?

Thanks

Hello,

Just an update, tried it again and it worked, I forgot to put the quotation marks

Thank you!