6 Replies Latest reply on Jul 6, 2016 7:08 PM by Sharon Hickox

    count member id as a negative

    Sharon Hickox

      Hi all


      A relatively new user....


      I have a simple workbook in which I need to count the number of members who have withdrawn monies over the past FY..


      I have negative values for the amount however am unsure how to 'count' the related Mbr ID's - bearing in mind that a member may have withdrawn on more than one occasion to be counted as ONE


      I have attached a sample test workbook for any assistance...


      Many thanks