Multiple Count IFs

[#1]

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

[Gysbert_Wassenaar]

See attached qvw.