4 Replies Latest reply: Feb 20, 2018 11:32 AM by Elizabeth Viso RSS

    Count if Contains Specific Letters

    Elizabeth Viso

      HELLO,

       

      I'm trying to get a count of a standard that contains the letters EC in there.

       

      I have a list of standards that have data like:

      EC.02.05.03

      EC.02.05.03

      EC.02.05.03

      EM.02.05.03

      LC.02.05.03

       

      So I'm trying to count how many start with EC and everything I've tried doesn't work.

      I tried the following:

       

      IF(INDEX(STANDARD,'EC')>0

       

      COUNT(IF(STANDARD='EC',STANDARD))

       

      if(trim(STANDARD)='EC'

       

      Nothing seems to work