Forum Discussion

Deleted's avatar
Deleted
Apr 24, 2017

Counting "Strongly Agree" and not "Agree"

Hello,

I am entering in survey results. I want to get to a point where I can copy and paste results (Strongly Agree to Strongly Disagree) and it will tell me how many times each answer was selected for each question. My current formulas are:

=COUNTIFS(K4:K96,"*Strongly agree*")

=COUNTIFS(K4:K96,"*Agree*")

=COUNTIFS(K4:K96,"*Neither agree nor disagree*")

=COUNTIFS(K4:K96,"*Disagree*")

=COUNTIFS(K4:K96,"*Strongly disagree*")

 

It worked great with strongly agree.... however when I got to the "Agree", it counted BOTH "Strongly Agree" and "Agree". Is there anyway around that? I have attached file for 

Thanks,
Sam

Formulas & Functions
Need Help

4 Replies

    • Deleted's avatar
      Deleted
      Apr 25, 2017
      Thank you for the response. I eliminated the ** and it solved the problem! Thank you, Detlef.
      Sam
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 24, 2017

    Hi Samuel,

     

    You forgot the file, thus it's not clear which strings you are calculating. Other words, why do you use astersisks in ctriteria. *Agree* means any sentence where above 5 letters sequence appears, includes Stronly Agree.

    • Deleted's avatar
      Deleted
      Apr 25, 2017
      That you for the help. I apologize for not uploading the file. I eliminated the * * and it corrected the issue. Thank you, Segei.
      Sam

Resources