EXCEL:

I have data with 20 different keys. For a question, I need to identify all rows that have matching values for TWO of these keys.

In the example, two of the keys are "Market Type" and "Product Type." For Market Type, the values are Major and Small. For Product Type, the values are Coffee, Tea, Expresso, and Herbal Tea.

For this question, I would need to find all rows that have a Major Market Type and a Coffee Product Type. After identifying those rows, I need to find the sum of their values for a different key.

What function would I use to identify the rows with matching Market Type AND Product Type?

Thank you!