5 Replies Latest reply on Sep 17, 2013 1:37 PM by Jeff Stanley

    simulating an excel countif function

    Jeff Stanley

      Working with a list of trades, each linked to a sales person and customer. I am currently counting how many individual account names are assigned to each sales person. How could I also calculate how many of those accounts we have done business with over the last 12 months? The fields I am using are "employee," "Account Name" and "Commission." I am using the countd function to find the number of customers and am guessing I could combine this function with some sort of "IF" statement to only count those customers that have generated commissions?