Spreadsheet: 41211d1239720569-countif-with-multiple-conditions-help_count
Sheet: List

 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 |  |  | 75
Discp | Emp Name | Emp A/NA | Pj  No. | [NAME] | Position | Client | Year | Consumed MHs | [NAME] | [NAME] | Remakrs | # of PM
INST | BLACK | A | 1111 | Single | PM | LOCAL | 2006-01-01 00:00:00 | 42395 | Large |  |  | P1
INST | [NAME] | NA | 1211 | Single | PM | JGC | 2006-01-01 00:00:00 | 21609 | Large |  |  | P1
PROC | BANJ | A | 1311 | Single | PM | JGC | 2006-01-01 00:00:00 | 13538 | Medium |  |  | P1
P. DIV. | [NAME] | A | 1411 | Single | PM | JGC | 2006-01-01 00:00:00 | 9708 | Medium |  |  | P1
ELEC | DES | NA | 1511 | Single | PM | JGC | 2006-01-01 00:00:00 | 8170 | Medium |  |  | P1
ELEC | AA | A | 1611 | Single | PM | JGC | 2006-01-01 00:00:00 | 4365 | Small |  |  | P1
PROC | KID | A | 1711 | Single | PM | JGC | 2006-01-01 00:00:00 | 4330 | Small |  |  | P1
P. DIV. | [NAME] | A | 1811 | Single | PM | JGC | 2006-01-01 00:00:00 | 3558 | Small |  |  | P1
P. DIV. | [NAME] | A | 1911 | Single | PM | LOCAL | 2006-01-01 00:00:00 | 2977 | Small |  |  | P2
MECH | [NAME] | A | 2011 | Single | PM | JGC | 2006-01-01 00:00:00 | 2900 | Small |  |  | P1
MECH | RED | A | 2111 | Single | PM | LOCAL | 2006-01-01 00:00:00 | 2783 | Small |  |  | P1
PROC | [NAME] | A | 2211 | Single | PM | JGC | 2006-01-01 00:00:00 | 2776 | Small |  |  | P1
PROC | SHARONE | A | 2311 | Single | PM | JGC | 2006-01-01 00:00:00 | 2627 | Small |  |  | P1
MECH | ALEX | A | 2411 | Single | PM | JGC | 2006-01-01 00:00:00 | 2510 | Small |  |  | P1
MECH | RED | A | 2711 | Single | PM | LOCAL | 2006-01-01 00:00:00 | 780 | Small |  |  | P2
P. DIV. | [NAME] | A | 2811 | Single | PM | JGC | 2006-01-01 00:00:00 | 716 | Small |  |  | P3
MECH | ALEX | A | 2911 | Single | PM | JGC | 2006-01-01 00:00:00 | 568 | Small |  |  | P2
MECH | RED | A | 3011 | Single | PM | LOCAL | 2006-01-01 00:00:00 | 563 | Small |  |  | P3
PROC | SHARONE | A | 3111 | Single | PM | JGC | 2006-01-01 00:00:00 | 469 | Small |  |  | P2
PROC | [NAME] | A | 3211 | Single | PM | JGC | 2007-01-01 00:00:00 | 36104 | Large |  |  | P1
PROC | PONTING | A | 3311 | Single | PM | JGC | 2007-01-01 00:00:00 | 9753 | Medium |  |  | P1
PIPNG | CLARK | A | 3411 | Single | PM | JGC | 2007-01-01 00:00:00 | 4768 | Small |  |  | P1
CIVIL | HARRY | A | 3511 | Single | PM | LOCAL | 2007-01-01 00:00:00 | 3246 | Small |  |  | P1
MECH | MAD | A | 3611 | Single | PM | JGC | 2007-01-01 00:00:00 | 2565 | Small |  |  | P1
CIVIL | GILL | A | 3711 | Single | PM | LOCAL | 2007-01-01 00:00:00 | 2028 | Small |  |  | P1
INST | CHILRIST | A | 3811 | Single | PM | LOCAL | 2007-01-01 00:00:00 | 1415 | Small |  |  | P1
CIVIL | GUL | A | 3911 | Single | PM | LOCAL | 2007-01-01 00:00:00 | 1325 | Small |  |  | P1
CIVIL | HARRY | A | 4011 | Single | PM | LOCAL | 2007-01-01 00:00:00 | 1090 | Small |  |  | P2
PROC | SHARONE | A | 4111 | Single | PM | JGC | 2007-01-01 00:00:00 | 1075 | Small |  |  | P1
MECH | ALEX | A | 4211 | Single | PM | JGC | 2007-01-01 00:00:00 | 1068 | Small |  |  | P1
CIVIL | GUL | A | 4311 | Single | PM | LOCAL | 2007-01-01 00:00:00 | 648 | Small |  |  | P2
PROC | SHARONE | A | 4411 | Single | PM | JGC | 2007-01-01 00:00:00 | 472 | Small |  |  | P2
INST | BLACK | A | 4511 | Single | PM | LOCAL | 2008-01-01 00:00:00 | 15847 | Large |  |  | P1
PIPNG | LEEMAN | A | 4611 | Single | PM | JGC | 2008-01-01 00:00:00 | 9530 | Medium |  |  | P1
MECH | ALEX | A | 4711 | Single | PM | JGC | 2008-01-01 00:00:00 | 6703 | Medium |  |  | P1
PIPNG | ALI | A | 4811 | Single | PM | JGC | 2008-01-01 00:00:00 | 3585 | Small |  |  | P1
PIPNG | ALI | A | 4911 | Single | PM | JGC | 2008-01-01 00:00:00 | 2151 | Small |  |  | P2
CIVIL | [NAME] | A | 5011 | Single | PM | LOCAL | 2008-01-01 00:00:00 | 1994 | Small |  |  | P1
INST | BLACK | A | 5111 | Single | PM | JGC | 2008-01-01 00:00:00 | 1834 | Small |  |  | P1
CIVIL | HARRY | A | 5211 | Single | PM | LOCAL | 2008-01-01 00:00:00 | 1509 | Small |  |  | P1
INST | FAISAL | A | 5311 | Single | PM | JGC | 2008-01-01 00:00:00 | 1400 | Small |  |  | P1
PROC | KID | A | 5411 | Single | PM | JGC | 2008-01-01 00:00:00 | 1345 | Small |  |  | P1
INST | FAISAL | A | 5511 | Single | PM | LOCAL | 2008-01-01 00:00:00 | 799 | Small |  |  | P2
PIPNG | RAJA RIZWAN AHMAD | A | 5611 | Single | PM | JGC | 2008-01-01 00:00:00 | 741 | Small |  |  | P1
PROC | KID | A | 5711 | Single | PM | LOCAL | 2008-01-01 00:00:00 | 448 | Small |  |  | P2
P. DIV. | KEVEN | A | 5811 | Multi | PM | LOCAL | 2006-01-01 00:00:00 | 76422 | Large |  |  | P1
ELEC | STRAUS | A | 5911 | Multi | PM | LOCAL | 2006-01-01 00:00:00 | 40591 | Large |  |  | P1
P. DIV. | BOTHAN | A | 6011 | Multi | PM | LOCAL | 2006-01-01 00:00:00 | 27783 | Large |  |  | P1
PIPNG | LEEMAN | A | 6111 | Multi | PM | LOCAL | 2006-01-01 00:00:00 | 2029 | Small |  |  | P1
MECH | RED | A | 6211 | Multi | PM | LOCAL | 2006-01-01 00:00:00 | 868 | Small |  |  | P1
PIPNG | LEEMAN | A | 6311 | Multi | PM | LOCAL | 2006-01-01 00:00:00 | 855 | Small |  |  | P2
P. DIV. | SAM | A | 6411 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 178999 | Large |  |  | P1
CIVIL | MEER | A | 6511 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 84045 | Large |  |  | P1
K-CIVIL | ALVAN | A | 6611 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 13329 | Medium |  |  | P1
P. DIV. | [NAME] | A | 6711 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 12532 | Medium |  |  | P1
K-PIPNG | AUSTON | A | 6811 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 11713 | Medium |  |  | P1
P. DIV. | [NAME] | A | 6911 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 10562 | Medium |  |  | P2
MECH | RED | A | 7011 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 8459 | Medium |  |  | P1
PIPNG | LEEMAN | A | 7111 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 6245 | Medium |  |  | P1
P. DIV. | TIMMY | A | 7211 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 2239 | Small |  |  | P1
P. DIV. | TIMMY | A | 7311 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 677 | Small |  |  | P2
K-PIPNG | OMAR QAMAR | A | 7411 | Multi | PM | LOCAL | 2007-01-01 00:00:00 | 484 | Small |  |  | P1
K-PIPNG | SAMMY | A | 7511 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 47173 | Large |  |  | P1
ELEC | DUMINY | A | 7611 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 46555 | Large |  |  | P1
P. DIV. | ARVAN | A | 7711 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 29124 | Large |  |  | P1
P. DIV. | [NAME] | A | 8011 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 13397 | Medium |  |  | P1
CIVIL | [NAME] | A | 8111 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 9854 | Medium |  |  | P1
MECH | RED | A | 8211 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 8733 | Medium |  |  | P1
CIVIL | [NAME] | A | 8311 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 6408 | Medium |  |  | P2
P. DIV. | TIMMY | A | 8511 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 3509 | Small |  |  | P1
P. DIV. | TIMMY | A | 8611 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 3064 | Small |  |  | P2
P. DIV. | [NAME] | A | 8811 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 1651 | Small |  |  | P1
P. DIV. | [NAME] | A | 8911 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 1475 | Small |  |  | P2
CIVIL | [NAME] | A | 9011 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 1058 | Small |  |  | P1
PROC | SHARONE | A | 9111 | Multi | PM | LOCAL | 2008-01-01 00:00:00 | 953 | Small |  |  | P1