I am summarizing a questionnaire where, out of 52 "Yes and No" questions (input as Y or N respectively), question 10, 19, 23, 24, 33, 37, 40, 45 that are answered Y need to be counted. I thought COUNTIFS would be my function of choice. This is the function I wrote:

=COUNTIFS(Data!N2:Data!N2,"=Y",Data!W2:Data!W2,"=Y",Data!AA2:Data!AA2,"=Y",Data!AB2:Data!AB2,"=Y",Data!AK2:Data!AK2,"=Y",Data!AO2:Data!AO2,"=Y",Data!AR2:Data!AR2,"=Y",Data!AW2:Data!AW2,"=Y")

I also tried without the duplicated cell:

=COUNTIFS(Data!N2,"=Y",Data!W2,"=Y",Data!AA2,"=Y",Data!AB2,"=Y",Data!AK2,"=Y",Data!AO2,"=Y",Data!AR2,"=Y",Data!AW2,"=Y")

And I tried without the equal sign:

=COUNTIFS(Data!N2,"Y",Data!W2,"Y",Data!AA2,"Y",Data!AB2,"Y",Data!AK2,"Y",Data!AO2,"Y",Data!AR2,"Y",Data!AW2,"Y")

I know items 23, 24, 33, 45 are answered Y, so the function should give me 4, but all of them give me 0.

Help Please!

In advance, thank you!

Linda