2 Replies Latest reply: May 3, 2016 3:13 AM by Ariel Topaz RSS

    countif values within table

    Ariel Topaz

      Hi

       

      i would like to know if there's a way to count values in different cells

      like this Example in excel

       

      COUNTIF(I6:M6, 2)*5+COUNTIF(I6:M6, 1)*1

      if there's a value '2' in range count it and multiple by 5

      if there's a value '1' in range count it and multiple by 1

       

       

      ABCDEScore
      000216
      000216
      001026
      010026
      021006
      002005
      002005
      000205

       

      i want to use it on straight / pivot table

      TNX

      Ariel