9 Replies Latest reply on Sep 28, 2016 11:07 AM by pooja.gandhi

    How do you Count only certain items?

    Anne Rogers

      I have a database where the data looks something like the below table.  I want to count ONLY the number of clients who bought BOTH items A and C during a quarter.  I have tired various calculations IF, ELSEIF, AND etc. but am not finding a way to count only those getting both items, it keeps count that plus those getting only or only C.  Anyone know how to do this?

       

      Client IDDate Item Payment
      1001/1/2016Ax
      1102/1/2016By
      1202/1/2016Cx
      1303/1/2016Dx
      1103/1/2016Cy
      1402/15/2016By
      1002/1/2016Cx
      1202/15/16Ax
      1304/1/2016Dx
      1504/1/2016Ay