CountIfs Function not working

[Groovy Chick]

Hi, I have two columns in a spreadsheet - one is a year and the other a data validation field yes/no. I want to count the number of instances of yes/no by year so wrote the following formula =

COUNTIFS(QNSAPList!$W:$W,"2011",$X:$X,"Open")

. However, it's returning zero. Can anyone tell me what I'm doing wrong? Many thanks.

 

[Groovy Chick]

Sorry, I meant count number of open/closed, not yes/no.

 

[RoryA]

Are you sure that shouldn't be:

COUNTIFS(QNSAPList!$W:$W,"2011",QNSAPList!$X:$X,"Open")

?

 

[Groovy Chick]

Oh lord! What an idiot! Thank you so much, Rory!

 

[RoryA]

Glad to help. (that's easily done, and hard to see when you did it!)

 

[Groovy Chick]

Glad to help. (that's easily done, and hard to see when you did it!)

Well, thanks again, and for not treating me like a total and utter numpty!