Help with Countif

[Guest]

I am trying to count the number of times red shows up in my list of data if
red is "open"

ColumnA ColumnB
Color Type

Red Open
Red Closed
Blue Open
Green Closed
Red Open

According to this list the answer should be 2. Thanks for your help.

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(A2:A1000="Red"),--(B2:B1000="Open"))

 

[Guest]

=SUMPRODUCT(--(A1:A10)="Red"),--(B1:B10="Open"))

 

[Guest]

Try:-

=SUMPRODUCT((A1:A10="Red")*(B1:B10="Open"))

Mike