Spreadsheet: 274433d1383123292-counting-unique-values-across-several-criteria-and-date-month-year-counting-unique-values
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if row<>"", if jan 2013, if CP1 then check for matching Program name & CP, if matches then see if assess has any "x", if yes, then = 0, else =1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP | Date | Group | Description |  | Time Frame | Problems
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-15 00:00:00 | FCS x001 | Yes, it will work |  |  | Group
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-15 00:00:00 | FCS x002 | Yes, it will work |  |  | CP1 | CP2 | CP3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-15 00:00:00 | FCS x003 | x |  | 2013-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-15 00:00:00 | FCS x004 | Yes, it will work |  | 2013-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-15 00:00:00 | FCS x005 | x |  | 2013-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-15 00:00:00 | FCS x006 | Yes, it will work |  | 2013-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x001 | Yes, it will work |  | 2013-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x002 | Yes, it will work |  | 2013-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x003 | Yes, it will work |  | 2013-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x004 | Yes, it will work |  | 2013-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x005 | Yes, it will work |  | 2013-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x006 | Yes, it will work |  | 2013-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-02 00:00:00 | EFJ x001 | Yes, it will work |  | 2013-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-02 00:00:00 | EFJ x002 | x |  | 2013-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-02 00:00:00 | [NAME] | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-02 00:00:00 | EFJ x004 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-02 00:00:00 | EFJ x005 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-02 00:00:00 | EFJ x006 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-02-01 00:00:00 | KH x001 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-02-01 00:00:00 | KH x002 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-02-01 00:00:00 | KH x003 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-02-01 00:00:00 | KH x004 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-02-01 00:00:00 | KH x005 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-02-01 00:00:00 | KH x006 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | FCS x001 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | FCS x002 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | FCS x003 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | FCS x004 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | FCS x005 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | FCS x006 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | KH x001 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | KH x002 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | KH x003 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | KH x004 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | KH x005 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP2 | 2013-02-28 00:00:00 | KH x006 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP3 | 2013-06-10 00:00:00 | FCS x001 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP3 | 2013-06-10 00:00:00 | FCS x002 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP3 | 2013-06-10 00:00:00 | FCS x003 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP3 | 2013-06-10 00:00:00 | FCS x004 | Yes, it will work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP3 | 2013-06-10 00:00:00 | FCS x005 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP3 | 2013-06-10 00:00:00 | FCS x006 | Yes, it will work