Spreadsheet: 127306d1320277339-sumproduct-help-extract-data-from-different-worksheets-within-the-same-workbook-test-5-ccm-reporting-sumproduct
Sheet: A data entry

ID | Reporting Quarter | Reporting Period | Target | Site |  |  |  | P 1 | Fiscal Quarter | Period | Start Date | End Date | Yes [NAME] | No | Site | Total Encounters
984 | Q 1 | P 1 | Yes | A |  |  |  | P 2 | Q 1 | P 1 | April 1,2011 | April 28,2011 |  |  | A
654 | Q 1 | P 1 | Yes | A |  |  |  | P 3 | Q 1 | P 2 | 2011-04-29 00:00:00 | 2011-05-26 00:00:00 |  |  | A
7546 | Q 1 | P 1 | NO | A |  |  |  | P 4 | Q 1 | P 3 | 2011-05-27 00:00:00 | June 23,2011 |  |  | A
5324 | Q 2 | P 1 | Yes | A |  |  |  | P 5 | Q 1 | P 1 | 2011-04-01 00:00:00 | April 28,2011 |  |  | B
35234 | Q 2 | P 2 | Yes | A |  |  |  | P 6 | Q 1 | P 2 | 2011-04-29 00:00:00 | 2011-05-26 00:00:00 |  |  | B
523423 | Q 2 | P 3 | Yes | A |  |  |  | P 7 | Q 1 | P 3 | 2011-05-27 00:00:00 | June 23,2011 |  |  | B
235 | Q 3 | P 1 | Yes | A |  |  |  | P 8 | Q 1 | P 1 | 2011-04-01 00:00:00 | April 28,2011 |  |  | C
3424 | Q 3 | P 1 | Yes | A |  |  |  | P 9 | Q 1 | P 2 | 2011-04-29 00:00:00 | 2011-05-26 00:00:00 |  |  | C
343 | Q 1 | P 4 | Yes | A |  |  |  | P 10 | Q 1 | P 3 | 2011-05-27 00:00:00 | June 23,2011 |  |  | C
23534 | Q 1 | P 5 | Yes | A |  |  |  | P 11 | Q 2 | P 4 | 2011-06-24 00:00:00 | 2011-07-21 00:00:00 |  |  | A
 |  |  |  |  |  |  |  | P 12 | Q 2 | P 5 | 2011-07-22 00:00:00 | 2011-08-18 00:00:00 |  |  | A
 |  |  |  |  |  |  |  | P 13 | Q 2 | P 6 | 2011-08-19 00:00:00 | 2011-09-15 00:00:00 |  |  | A
 |  |  |  |  |  |  |  |  | Q 2 | P 4 | 2011-06-24 00:00:00 | 2011-07-21 00:00:00 |  |  | B
 |  |  |  |  |  |  |  |  | Q 2 | P 5 | 2011-07-22 00:00:00 | 2011-08-18 00:00:00 |  |  | B
 |  |  |  |  |  |  |  |  | Q 2 | P 6 | 2011-08-19 00:00:00 | 2011-09-15 00:00:00 |  |  | B
 |  |  |  |  |  |  |  |  | Q 2 | P 4 | 2011-06-24 00:00:00 | 2011-07-21 00:00:00 |  |  | C
 |  |  |  |  |  |  |  |  | Q 2 | P 5 | 2011-07-22 00:00:00 | 2011-08-18 00:00:00 |  |  | C
 |  |  |  |  |  |  |  |  | Q 2 | P 6 | 2011-08-19 00:00:00 | 2011-09-15 00:00:00 |  |  | C
 |  |  |  |  |  |  |  |  | Q 3 | P 7 | 2011-09-16 00:00:00 | 2011-10-13 00:00:00 |  |  | A
 |  |  |  |  |  |  |  |  | Q 3 | P 8 | 2011-10-14 00:00:00 | 2011-11-10 00:00:00 |  |  | A
 |  |  |  |  |  |  |  |  | Q 3 | P 9 | 2011-11-11 00:00:00 | 2011-12-08 00:00:00 |  |  | A
 |  |  |  |  |  |  |  |  | Q 3 | P 7 | 2011-09-16 00:00:00 | 2011-10-13 00:00:00 |  |  | B
 |  |  |  |  |  |  |  |  | Q 3 | P 8 | 2011-10-14 00:00:00 | 2011-11-10 00:00:00 |  |  | B
 |  |  |  |  |  |  |  |  | Q 3 | P 9 | 2011-11-11 00:00:00 | 2011-12-08 00:00:00 |  |  | B
 |  |  |  |  |  |  |  |  | Q 3 | P 7 | 2011-09-16 00:00:00 | 2011-10-13 00:00:00 |  |  | C
 |  |  |  |  |  |  |  |  | Q 3 | P 8 | 2011-10-14 00:00:00 | 2011-11-10 00:00:00 |  |  | C
 |  |  |  |  |  |  |  |  | Q 3 | P 9 | 2011-11-11 00:00:00 | 2011-12-08 00:00:00 |  |  | C
 |  |  |  |  |  |  |  |  | Q 4 | P 10 | 2011-12-09 00:00:00 | 2012-01-05 00:00:00 |  |  | A
 |  |  |  |  |  |  |  |  | Q 4 | P 11 | 2012-01-06 00:00:00 | 2012-02-02 00:00:00 |  |  | A
 |  |  |  |  |  |  |  |  | Q 4 | P 12 | 2012-02-03 00:00:00 | 2012-03-01 00:00:00 |  |  | A
 |  |  |  |  |  |  |  |  | Q 4 | P 13 | 2012-03-02 00:00:00 | 2012-03-31 00:00:00 |  |  | A
 |  |  |  |  |  |  |  |  | Q 4 | P 10 | 2011-12-09 00:00:00 | 2012-01-05 00:00:00 |  |  | B
 |  |  |  |  |  |  |  |  | Q 4 | P 11 | 2012-01-06 00:00:00 | 2012-02-02 00:00:00 |  |  | B
 |  |  |  |  |  |  |  |  | Q 4 | P 12 | 2012-02-03 00:00:00 | 2012-03-01 00:00:00 |  |  | B
 |  |  |  |  |  |  |  |  | Q 4 | P 13 | 2012-03-02 00:00:00 | 2012-03-31 00:00:00 |  |  | B
 |  |  |  |  |  |  |  |  | Q 4 | P 10 | 2011-12-09 00:00:00 | 2012-01-05 00:00:00 |  |  | C
 |  |  |  |  |  |  |  |  | Q 4 | P 11 | 2012-01-06 00:00:00 | 2012-02-02 00:00:00 |  |  | C
 |  |  |  |  |  |  |  |  | Q 4 | P 12 | 2012-02-03 00:00:00 | 2012-03-01 00:00:00 |  |  | C
 |  |  |  |  |  |  |  |  | Q 4 | P 13 | 2012-03-02 00:00:00 | 2012-03-31 00:00:00 |  |  | C