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
    • 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
    MVP
    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