1 2 Previous Next 24 Replies Latest reply on Mar 15, 2016 1:33 PM by Diogo Braga

    SUM IF Responses = "Strongly Agree" "Somewhat Agree" "Agree"

    Diogo Braga

      The data set is from a 6 point Likert scale survey responses.


      I have percentages for strongly agree, agree, somewhat agree, somewhat disagree, disagree, and strongly disagree


      I need to create a calculated field to calculate the Total Agree.


      I unsuccessfully tried...


      IF [Response] = "Strongly Agree" "Somewhat Agree" "Agree"


      SUM [Response]



      Please help!

        1 2 Previous Next