2 Replies Latest reply on Oct 3, 2018 11:10 AM by tarang.patel.3

    Summing only  certain rows of data in calculations

    tarang.patel.3

      Hi all,

       

      I need to sum the "Number of Employees" for each Company, but need to exclude a row of data if there is a duplicate value within each customer. See example below.

      For customer H only the first 260,000 should be part of a sum formula and for Customer I both the 1 and 20 should be part of the sum formula.

       

      I tried a few solutions, but use cases like customer K created some road blocks.

       

      Note: the "Include?" column is only for reference.

       

       

       

       

      Thanks for the help!

         

      Company IDCorporate NameNumber of EmployeesInclude?
      51071A12Yes
      51312B16Yes
      51033C19Yes
      51374D80Yes
      50805E300Yes
      51126D500Yes
      51207E710Yes
      51218F25,105Yes
      50709G126,000Yes
      51070H260,000Yes
      51070H260,000No
      51092I1Yes
      51093I20Yes
      51094J19Yes
      51095J19No
      50401K500Yes
      50306K120Yes
      50209K30Yes
      50099K9Yes
      50088K500No
      50077K17Yes