Spreadsheet: 274436d1383124284-counting-unique-values-across-several-criteria-and-date-month-year-counting-unique-values-2
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 |  | Jan 2013 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-15 00:00:00 | FCS x004 | Yes, it will work |  | Feb 2013 | 0 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-15 00:00:00 | FCS x005 | x |  | Mar 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-15 00:00:00 | FCS x006 | Yes, it will work |  | Apr 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x001 | Yes, it will work |  | May 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x002 | Yes, it will work |  | Jun 2013 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x003 | Yes, it will work |  | Jul 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x004 | Yes, it will work |  | Aug 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x005 | Yes, it will work |  | Sep 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-23 00:00:00 | AM x006 | Yes, it will work |  | Oct 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-02 00:00:00 | EFJ x001 | Yes, it will work |  | Nov 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CP1 | 2013-01-02 00:00:00 | EFJ x002 | x |  | Dec 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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