Hi, all!

I've got a calendar-style sheet (sheet 3) that I'm pulling data from, and I've got the categories in 2 different dropdown menus on a second sheet (sheet 4). I'm trying to get a cell to add up all of the occurrences of certain text within the calendar.

I've figured out how to accomplish this with one dropdown menu because I can just have it referencing individual rows, but I can't quite get the second dropdown to influence which row it's pulling from.

=SUMPRODUCT(--EXACT(C10, Sheet3!4:4))

C10 is the first dropdown menu. H10 is the second dropdown menu, and it should help select the row being referenced on sheet 3. I tried using INDEX, but I think I did it incorrectly.

Any help is much appreciated!