Spreadsheet: 329623d1404370822-counting-clients-and-sum-total-counting-query-v3
Sheet: Training

 |  |  | Sector | Month of Training |  | Unit Code |  |  |  | Fund |  |  |  |  |  |  | count |  |  |  | Count of clients with WD / WD | Count of number total with WD / WD from cell "DATA" @ AH
 |  |  | AGR | 2014-06-01 00:00:00 | AHC20110 | AHCCHM201A |  |  |  | P |  |  |  |  |  |  | 2 |  |  |  | 3
 |  |  | DAI | 2014-06-01 00:00:00 | AHC20110 | AHCCHM201A |  |  |  | P |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | AGR | 2014-10-01 00:00:00 | AHC20110 | AHCDRY201A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | DAI | 2014-10-01 00:00:00 | AHC20110 | AHCDRY201A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | AGR | 2014-07-01 00:00:00 | AHC20110 | AHCINF202A |  |  |  | L |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | DAI | 2014-07-01 00:00:00 | AHC20110 | AHCINF202A |  |  |  | L |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | AGR | 2014-04-01 00:00:00 | AHC20110 | AHCLSK202A |  |  |  | L |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | DAI | 2014-04-01 00:00:00 | AHC20110 | AHCLSK202A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | AGR | 2014-03-01 00:00:00 | AHC20110 | AHCLSK205A |  |  |  | P |  |  |  |  |  |  | 3 |  |  |  | 3
 |  |  | DAI | 2014-03-01 00:00:00 | AHC20110 | AHCLSK205A |  |  |  | P |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | AGR | 2014-10-01 00:00:00 | AHC20110 | AHCLSK209A |  |  |  | L |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | DAI | 2014-10-01 00:00:00 | AHC20110 | AHCLSK209A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | AGR | 2014-04-01 00:00:00 | AHC20110 | AHCLSK211A |  |  |  | L |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | DAI | 2014-04-01 00:00:00 | AHC20110 | AHCLSK211A |  |  |  | L |  |  |  |  |  |  | 2 |  |  |  | 2
 |  |  | AGR | 2014-05-01 00:00:00 | AHC20110 | AHCMOM202A |  |  |  | P |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | DAI | 2014-05-01 00:00:00 | AHC20110 | AHCMOM202A |  |  |  | P |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | AGR | 2014-07-01 00:00:00 | AHC20110 | AHCMOM207A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | DAI | 2014-07-01 00:00:00 | AHC20110 | AHCMOM207A |  |  |  | L |  |  |  |  |  |  | 2 |  |  |  | 2
 |  |  | DAI | 2014-11-01 00:00:00 | AHC20110 | AHCMOM212A |  |  |  | P |  |  |  |  |  |  | 6 |  |  |  | 7
 |  |  | AGR | 2014-12-01 00:00:00 | AHC20110 | AHCMOM212A |  |  |  | P |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | AGR | 2014-01-01 00:00:00 | AHC20110 | AHCOHS201A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 2
 |  |  | DAI | 2014-01-01 00:00:00 | AHC20110 | AHCOHS201A |  |  |  | L |  |  |  |  |  |  | 3 |  |  |  | 3
 |  |  | AGR | 2014-05-01 00:00:00 | AHC20110 | AHCPMG201A |  |  |  | P |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | DAI | 2014-05-01 00:00:00 | AHC20110 | AHCPMG201A |  |  |  | P |  |  |  |  |  |  | 2 |  |  |  | 2
 |  |  | DAI | 2014-10-01 00:00:00 | AHC20110 | AHCSOL201A |  |  |  | L |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | AGR | 2014-07-01 00:00:00 | AHC20110 | AHCSOL201A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | AGR | 2014-10-01 00:00:00 | AHC20110 | AHCWRK201A |  |  |  | L |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | DAI | 2014-10-01 00:00:00 | AHC20110 | AHCWRK201A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  | AGR | 2014-06-01 00:00:00 | AHC20110 | AHCWRK202A |  |  |  | P |  |  |  |  |  |  | 1 |  |  |  | 2
 |  |  | DAI | 2014-06-01 00:00:00 | AHC20110 | AHCWRK202A |  |  |  | P |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | DAI | 2014-10-01 00:00:00 | AHC20110 | AHCWRK204A |  |  |  | P |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | AGR | 2014-11-01 00:00:00 | AHC20110 | AHCWRK204A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 2
 |  |  | AGR | 2014-11-01 00:00:00 | AHC20110 | AHCWRK205A |  |  |  | P |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  | DAI | 2014-11-01 00:00:00 | AHC20110 | AHCWRK205A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 2
 |  |  | AGR | 2014-04-01 00:00:00 | AHC20110 | HLTFA201A |  |  |  | L |  |  |  |  |  |  | 2 |  |  |  | 3
 |  |  | DAI | 2014-04-01 00:00:00 | AHC20110 | HLTFA201A |  |  |  | L |  |  |  |  |  |  | 1 |  |  |  | 2