3 Replies Latest reply on Apr 5, 2018 12:42 PM by Jim Dehner

    Sum disticnt based on another column

    alex.rondon

      I am trying to sum column "A" if the values in Column "B" values are distinct. For example:

       

      The sum for the table below should be

      DRF3 = 1

      ABC1 = 1

      FGD   = 1

       

      Column AColumn B
      DRF31
      DRF31
      DRF31
      ABC11
      FGD31