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

Try this:

=SUMPRODUCT(--(A1:A25="B"),--(B1:B25="Y"))

--
Biff
Microsoft Excel MVP


"AD Carvajal" <AD wrote in message
...
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