Excel 2007 COUNTIF Help

[KJ2607]

Hi There

I'm trying to write a formula so that if "Red" appears in the A Column, I need to count how many times "Yes" appears in the D Column:

[TABLE="width: 345"]
<colgroup><col span="4"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Open/Closed?[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Red[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Yellow[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Yellow[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Red[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]no[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Green[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Green[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]no[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]Green[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]no[/TD]
[/TR]
</tbody>[/TABLE]

I've tried writing a few versions but I just can't seem to get the formula right - Obviously I know the answer for this example would be "1" but the Worksheet I'm working on is going to have much more information that I need count.

Any help would be greatly appreciated!

Thanks

 

[VoG]

Try

=COUNTIFS(A1:A10,"Red",D1:D10,"yes")

 

[KJ2607]

Thats just what I was looking for...Thanks!!