worksheet function help

[Mike]

I want to use the countif function in one column, but I only want to
count cells if the corresponding row in another column contains a
certain value.

IE
Column 1 Column 2
1 Open 1 X
2 Closed 2 X
3 Open 3 X

I only want to count the X's that are associated with Open in column
1. Is there a way to do this without typing in each cell?

 

[Paul Lautman]

Since every value in column 2 seems to be X, couldn't you just do your
countif column 1 contains Open?