1 Reply Latest reply: Feb 9, 2015 6:18 AM by Gysbert Wassenaar RSS

    Multiple Count IFs

      Hi

       

      I am trying to create a count IF check with two variables. I want to count the number of entries which have existed for over two years and it has been two years since they have been inspected and return their identification.

       

      This is the formula I have created so far, but it does not work.

       

      Count({<Today()-StartDate>730, Today()-InspectionDate>730>} ID)

       

      The check in Excel is =IF(AND(TODAY()-C5>730,TODAY()-D5>730),1,0)

       

      IDCompanyStart DataInspection Date
      1A01/06/201213/09/20140
      2B05/07/201400
      3C25/10/201001
      4B26/04/201101
      5A26/04/201120/10/20130
      6C26/04/201101
      7A05/07/201400
      8B26/04/201101
      9C05/07/201400
      10B05/07/201001

       

      Then count the number of occasions it happens for each company

       

      A 0

      B 3

      C 2

       

      Any help would be appreciated.

       

      Thanks,

       

      Iain