Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
ID | Company | Start Data | Inspection Date | |
1 | A | 01/06/2012 | 13/09/2014 | 0 |
2 | B | 05/07/2014 | 0 | 0 |
3 | C | 25/10/2010 | 0 | 1 |
4 | B | 26/04/2011 | 0 | 1 |
5 | A | 26/04/2011 | 20/10/2013 | 0 |
6 | C | 26/04/2011 | 0 | 1 |
7 | A | 05/07/2014 | 0 | 0 |
8 | B | 26/04/2011 | 0 | 1 |
9 | C | 05/07/2014 | 0 | 0 |
10 | B | 05/07/2010 | 0 | 1 |
Then count the number of occasions it happens for each company
A 0
B 3
C 2
Any help would be appreciated.
Thanks,
Iain
See attached qvw.