3 Replies Latest reply on Aug 8, 2013 11:49 AM by Kerith Gaines

    count x value but exclude similar x value

    Kerith Gaines

      Hey Everyone!


      I'm scratching my head over setting up the count logic for this. I need to count the number of times "Blue" shows up in a column, and I need to exclude "Dark-Blue" - I tried the following:


      if contains ([Color], "Blue") then "1"

      elseif contains ([Color], "Dark-Blue") then "0"



      But because Dark-Blue still has "Blue" in it, the Dark-Blue values are still being counted by the first if statement.


      How do I exclude Dark-Blue from the count?


      Thank you so much for your help!