6 Replies Latest reply: May 13, 2015 5:10 AM by Robert Mika RSS

    How to sum of quantity product based

      i have 2 excels sheet

       

      1) product

      2) product quantity

       

       

        product:

      productcodename
      101panadol
      102dispren
      103levlox
      105augmenten
      106ethrocin

       

        product quantity:

      productcodeqty
      10134
      10155
      10166
      10123
      10255
      10266
      10233
      10323
      10366
      10377
      10588
      10699
      106100

       

      how to make sum of qty  like ( after distinct, sum should  come.. i guess ....)

       

      product 101 sum should be 178


      product 102  sum should be 154  


      product 106  sum should be 199   and so



      i need to show it on chart


      kindly help me