I'm sorry but I don't know how to google this. I have a table that looks like this:
response|item| categoryA| categoryB
----------------------------------------------
Yes item1 item1 item2
No item2 item3 item4
No item3
yes item4
No item1
Yes item2
Each item belongs to one of two categories: A or B. The items are also listed in the 'item' column. Each item appears in the Item column multiple times, but only in the Category lookup columns once. Each instance of an item comes with a response, yes or no. I need a count of how often the category A and B items receive a 'Yes' response, respectively.
For instance: the table above would yield
Category A: 1 Category B: 2
Thank you,