In the following spreadsheet, I need to count the number of times "y" appears
in the Guest column when B appears in the Site column. Is there any way to
do this with one formula

Site Guest
E n
E n
E n
E n
E n
E n
E n
E n
E y
E n
B n
B n
B y
B y
E n
E n
E y
E y
E n
E n
A n
A n
A y
A y
A n