Hello,
I've got a 6 questions in a survey asking in different ways whether someone feels better after using our service.
People can answer Strongly agree, Agree, Neutral, Disagree or Strongly disagree to each of the 6 questions.
I want to do a calculation to see how many people answered "Strongly agree" or "Agree" to every single question.
I have 163 responses
Each of the 6 questions are in different columns. The data is in A2:F165
For a single response I thought I could do
=if(
(countif(A2:F2, "Strongly agree")
+
countif(A2:F2, "Agree"))
=6,
True)
I want to count the number of "True" responses across all of the data. I feel an array formula is the way forward but I don't understand how to use them.
Thanks!

I've got a 6 questions in a survey asking in different ways whether someone feels better after using our service.
People can answer Strongly agree, Agree, Neutral, Disagree or Strongly disagree to each of the 6 questions.
I want to do a calculation to see how many people answered "Strongly agree" or "Agree" to every single question.
I have 163 responses
Each of the 6 questions are in different columns. The data is in A2:F165
For a single response I thought I could do
=if(
(countif(A2:F2, "Strongly agree")
+
countif(A2:F2, "Agree"))
=6,
True)
I want to count the number of "True" responses across all of the data. I feel an array formula is the way forward but I don't understand how to use them.
Thanks!

