Help with Countif

R

Rikuk

:confused: Can any one help with this please I need to count the number
times a condition is meet in two cells.
IF A1=RED AND B1=YES
ie.

A B
1 RED YES
2 BLUE NO
3 RED NO
4 BLUE NO
5 RED YES

RESULT WOULD BE
RED YES=2
RED NO=1

Thanks
Rik
 
R

Ron Coderre

Using your data in cells A1:B5

D1: RED
E1: Yes
F1: =SUMPRODUCT(($A$1:$A$5=D1)*($B$1:$B$5=E1))

Also, if you give you list column headings (like:Color, Y/N) you could
use a pivot table to summarize your data.

Does that help?

Regards,
Ron
 
Top