10 Replies Latest reply: Jul 15, 2014 1:57 PM by Herbert Chitate RSS

    Count Active Customers

      Hi All,

       

      A very quick question. I have a client master list with client numbers (which is incomplete) and a database with a list of client transactions. I need to count the number of active clients that I have on board. Active clients is defined as all clients on the client master list + any clients in the transaction database that has sales in the year 2014, but are not in the master client list. I have attached some dummy data. (formula in a simple text box will be ok)

       

      Any assistance appreciated.

       

      Thank you

       

      H