Yes, you're right.
This will work:
sum(countifop("==","1",S1Q2_SQ001.NAOK, S1Q2_SQ002.NAOK, S1Q2_SQ003.NAOK, S1Q2_SQ004.NAOK, S1Q2_SQ021.NAOK, S1Q2_SQ022.NAOK, S1Q2_SQ023.NAOK, S1Q2_SQ024.NAOK, S1Q2_SQ017.NAOK, S1Q2_SQ018.NAOK, S1Q2_SQ019.NAOK, S1Q2_SQ028.NAOK, S1Q2_SQ029.NAOK, S1Q2_SQ030.NAOK), countifop("==","2",S1Q2_SQ001.NAOK, S1Q2_SQ002.NAOK, S1Q2_SQ003.NAOK, S1Q2_SQ004.NAOK, S1Q2_SQ021.NAOK, S1Q2_SQ022.NAOK, S1Q2_SQ023.NAOK, S1Q2_SQ024.NAOK, S1Q2_SQ017.NAOK, S1Q2_SQ018.NAOK, S1Q2_SQ019.NAOK, S1Q2_SQ028.NAOK, S1Q2_SQ029.NAOK, S1Q2_SQ030.NAOK))>0
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.