Count with multiple column criteria

[Joe M.]

I am trying to count the occurance of criteria in more than one column. A
simple example:
A B
1 Red Y
2 Red N
3 Red Y
4 Red N
5 Red N
6 Green Y
7 Green N

I would like to count the number of times column A ="Red" and the associated
cell in column B="Y". The result should be 2.

Thanks,
Joe M.

 

[Tim879]

Try this (assuming your spreadsheet is set up as noted below)
=SUMPRODUCT(($A$1:$A$7="Red")*($B$1:$B$7="Y"))

 

[Teethless mama]

=SUMPRODUCT(--(A1:A100="Red"),--(B1:B100="Y"))