Spreadsheet: 111033d1307545429-countif-and-sum-test
Sheet: Sheet1

TM | Name | Stats | ID# | AVAYA | Time Calld | STAT ALERT SENT | REASON | Date (mm/dd/yyyy) | Total Time | GROUP
[NAME] | [NAME] | ACW > 5 MIN | 8070820 | 46901 | 09:05:00 | no | In-Late | 2011-06-01 00:00:00 | 05:01:00 | WCBB
Danielle Verreault | Sylvie [NAME] | ACW > 5 MIN | 2002290 | 46336 | 09:07:00 | no | Working on Account | 2011-06-01 00:00:00 | 05:00:00 | WCBB
[NAME] | Cristian Alday | ACW > 5 MIN | 6670990 | 46763 | 09:10:00 | no | In-Late | 2011-06-01 00:00:00 | 05:31:00 | WCBB
[NAME] | [NAME] | ACW > 5 MIN | 6249800 | 46735 | 09:38:00 | no | Follow-up | 2011-06-01 00:00:00 | 06:32:00 | WCSE
Danielle Verreault | [NAME] | AUX >2 MIN | 6213560 | 46360 | 09:55:00 | no | Other | 2011-06-01 00:00:00 | 08:34:00 | WCBB
Romina Pasquariello | [NAME] | ACW > 5 MIN | 6323180 | 46071 | 09:58:00 | yes | No Answer | 2011-06-01 00:00:00 | 09:04:00 | LCBB
Danielle Verreault | [NAME] | ACW > 5 MIN | 6030560 | 46348 | 10:07:00 | no | Working on Account | 2011-06-01 00:00:00 | 06:32:00 | WCBB
Danielle Verreault | Sylvie [NAME] | AUX >2 MIN | 2002290 | 46336 | 10:12:00 | no | [NAME] | 2011-06-01 00:00:00 | 03:32:00 | WCSE
[NAME] | [NAME] | ACW > 5 MIN | 8166220 | 46712 | 10:16:00 | yes | No Answer | 2011-06-01 00:00:00 | 08:03:00 | WCSE
[NAME] | Didier [NAME] | AUX >2 MIN | 8345910 | 46444 | 10:35:00 | no | In-Late | 2011-06-01 00:00:00 | 04:31:00 | SCBB
[NAME] | [NAME] | ACW > 5 MIN | 6929910 | 46378 | 10:43:00 | no | [NAME] | 2011-06-01 00:00:00 | 07:33:00 | LCB1
[NAME] | [NAME] | ACW > 5 MIN | 8414930 | 46747 | 10:48:00 | no | Forgot on ACW/AUX | 2011-06-01 00:00:00 | 07:03:00 | WCSE
[NAME] | Ravinder Dhillon | ACW > 5 MIN | 6650620 | 46629 | 10:50:00 | no | No Answer | 2011-06-01 00:00:00 | 06:32:00 | LCB1
[NAME] | [NAME] | AUX >2 MIN | 6955310 | 46839 | 10:52:00 | no | With TM Coaching | 2011-06-01 00:00:00 | 04:32:00 | WCBB
[NAME] | [NAME] | AUX >2 MIN | 2007360 | 46711 | 10:54:00 | no | With TM Coaching | 2011-06-01 00:00:00 | 03:32:00 | WCSE
[NAME] | [NAME] | ACW > 5 MIN | 6130020 | 46704 | 11:03:00 | no | Forgot on ACW/AUX | 2011-06-01 00:00:00 | 05:32:00 | WCBB
[NAME] | [NAME] | AUX >2 MIN | 8161360 | 46317 | 11:05:00 | no | In-Late | 2011-06-01 00:00:00 | 03:30:00 | [NAME]
Maxime Nivose | [NAME] | AUX >2 MIN | 6192270 | 46768 | 11:28:00 | no | Working on Account | 2011-06-01 00:00:00 | 03:31:00 | WCBB
Maxime Nivose | Guillaume Breant | ACW > 5 MIN | 8154830 | 46775 | 11:47:00 | no | Forgot on ACW/AUX | 2011-06-01 00:00:00 | 07:33:00 | WCBB
Danielle Verreault | [NAME] | ACW > 5 MIN | 6290980 | 46371 | 12:46:00 | no | With TM Coaching | 2011-06-01 00:00:00 | 07:32:00 | WCBB
[NAME] | [NAME] | ACW > 5 MIN | 6278210 | 46051 | 12:54:00 | yes | No Answer | 2011-06-01 00:00:00 | 10:34:00 | WCBB
[NAME] | [NAME] | ACW > 5 MIN | 6209900 | 46676 | 12:57:00 | no | Working on Account | 2011-06-01 00:00:00 | 07:02:00 | WCSE
[NAME] | [NAME] | ACW > 5 MIN | 8415530 | 46326 | 13:12:00 | yes | No Answer | 2011-06-01 00:00:00 | 06:04:00 | WCSE
[NAME] | [NAME] | ACW > 5 MIN | 6635220 | 46627 | 13:29:00 | no | Forgot on ACW/AUX | 2011-06-01 00:00:00 | 07:33:00 | LCB1
[NAME] | [NAME] | AUX >2 MIN | 8333720 | 46774 | 13:41:00 | NO | No Answer | 2011-06-01 00:00:00 | 06:01:00 | WCBB
[NAME] | Didier [NAME] | ACW > 5 MIN | 8345910 | 46444 | 13:44:00 | no | Switched States | 2011-06-01 00:00:00 | 06:01:00 | SCBB
Maxime Nivose | Michel Athis | ACW > 5 MIN | 8154480 | 46788 | 13:56:00 | no | Follow-up | 2011-06-01 00:00:00 | 09:04:00 | WCBB
Romina Pasquariello | Yolande Monfison | ACW > 5 MIN | 8022820 | 46057 | 13:56:00 | no | Forgot on ACW/AUX | 2011-06-01 00:00:00 | 08:02:00 | LCB1
[NAME] | [NAME] | ACW > 5 MIN | 8163160 | 46317 | 14:13:00 | no | Forgot on ACW/AUX | 2011-06-01 00:00:00 | 06:29:00 | [NAME]
[NAME] | [NAME] | ACW > 5 MIN | 6081230 | 46767 | 14:14:00 | no | Working on Account | 2011-06-01 00:00:00 | 07:00:00 | WCBB
Richere Jolicoeur | [NAME] | ACW > 5 MIN | 8132800 | 46403 | 14:20:00 | no | Working on Account | 2011-06-01 00:00:00 | 06:01:00 | SCBB
[NAME] | [NAME] | ACW > 5 MIN | 8396620 | 46332 | 14:24:00 | no | Working on Account | 2011-06-01 00:00:00 | 07:03:00 | WCSE
Romina Pasquariello | [NAME] | ACW > 5 MIN | 6323180 | 46071 | 14:25:00 | no | Switched States | 2011-06-01 00:00:00 | 08:03:00 | LCBE
Romina Pasquariello | [NAME] | ACW > 5 MIN | 6175370 | 46778 | 14:40:00 | no | Tech Issue | 2011-06-01 00:00:00 | 05:30:00 | LCB1
[NAME] | [NAME] | ACW > 5 MIN | 6480710 | 46310 | 14:45:00 | no | Forgot on ACW/AUX | 2011-06-01 00:00:00 | 05:30:00 | WCSE
[NAME] | [NAME] | ACW > 5 MIN | 8070820 | 46901 | 14:46:00 | no | Working on Account | 2011-06-01 00:00:00 | 07:01:00 | WCBB
[NAME] | Dominique Pare | AUX >2 MIN | 6159030 |  | 14:51:00 | no | No Answer | 2011-06-01 00:00:00 | 02:59:00 | WCLB
[NAME] | Valeria Panzera | ACW > 5 MIN | 8387850 | 46324 | 14:53:00 | no | Follow-up | 2011-06-01 00:00:00 | 06:01:00 | WCSE
[NAME] | [NAME] | ACW > 5 MIN | 6330280 | 46833 | 14:58:00 | no | Switched States | 2011-06-01 00:00:00 | 06:32:00 | RCAB
[NAME] | [NAME] | ACW > 5 MIN | 6717470 | 46836 | 14:59:00 | no | Switched States | 2011-06-01 00:00:00 | 07:31:00 | RCAB
[NAME] | Etienne Beaupre Demers | ACW > 5 MIN | 8056390 | 46333 | 15:01:00 | no | With TM Assistance | 2011-06-01 00:00:00 | 06:31:00 | WCSE
[NAME] | [NAME] | AUX >2 MIN | 6480710 | 46310 | 15:02:00 | yes | No Answer | 2011-06-01 00:00:00 | 04:01:00 | WCSE
Danielle Verreault | [NAME] | ACW > 5 MIN | 6883730 | 46039 | 15:06:00 | no | Switched States | 2011-06-01 00:00:00 | 06:32:00 | WCBB
[NAME] | [NAME] | AUX >2 MIN | 8070830 | 46751 | 15:06:00 | yes | No Answer | 2011-06-01 00:00:00 | 05:32:00 | WCBB
[NAME] | [NAME] | ACW > 5 MIN | 6330280 | 46833 | 15:12:00 | no | With TM Assistance | 2011-06-01 00:00:00 | 08:00:00 | RCAB
[NAME] | [NAME] | AUX >2 MIN | 6021860 | 46319 | 15:34:00 | yes | No Answer | 2011-06-01 00:00:00 | 05:00:00 | WCSE
[NAME] | [NAME] | ACW > 5 MIN | 6718580 | 46451 | 15:55:00 | no | Follow-up | 2011-06-01 00:00:00 | 07:00:00 | RCAB
[NAME] | taina Innocent | ACW > 5 MIN | 6665840 | 46635 | 16:07:00 | no | In-Late | 2011-06-01 00:00:00 | 08:33:00 | RCAB
[NAME] | [NAME] | ACW > 5 MIN | 8067330 | 46325 | 16:13:00 | no | In-Late | 2011-06-01 00:00:00 | 10:01:00 | WCBB
[NAME] | taina Innocent | ACW > 5 MIN | 6665840 | 46635 | 16:28:00 | no | Working on Account | 2011-06-01 00:00:00 | 07:30:00 | RCAB
[NAME] | Veronique Hache | ACW > 5 MIN | 6109550 |  | 16:59:00 | no | Switched States | 2011-06-01 00:00:00 | 06:32:00 | WCSE
[NAME] | [NAME] | AUX >2 MIN | 6323310 | 46364 | 17:02:00 | no | In-Late | 2011-06-01 00:00:00 | 06:31:00 | LCBE
Romina Pasquariello | [NAME] | ACW > 5 MIN | 6965790 | 46845 | 17:06:00 | no | In-Late | 2011-06-01 00:00:00 | 08:31:00 | LCBE
[NAME] | [NAME] | ACW > 5 MIN | 8396660 | 46355 | 18:25:00 | no | Working on Account | 2011-06-01 00:00:00 | 07:31:00 | WCBB
[NAME] | Rand Hujeir | ACW > 5 MIN | 6925110 | 46754 | 18:26:00 | no | Follow-up | 2011-06-01 00:00:00 | 06:31:00 | WCBB
[NAME] | taina Innocent | ACW > 5 MIN | 6665840 | 46635 | 18:34:00 | no | Forgot break/lunch/EOD | 2011-06-01 00:00:00 | 06:00:00 | RCAB
[NAME] | [NAME] | ACW > 5 MIN | 2001340 | 46751 | 18:49:00 | no | Switched States | 2011-06-01 00:00:00 | 06:01:00 | WCBB
[NAME] | Irving Athis | ACW > 5 MIN | 8028930 | 46328 | 19:26:00 | no | Working on Account | 2011-06-01 00:00:00 | 10:32:00 | WCSE
[NAME] | [NAME] | AUX >2 MIN | 6331650 | 46836 | 19:31:00 | no | Forgot break/lunch/EOD | 2011-06-01 00:00:00 | 18:03:00 | RCAB
[NAME] | [NAME] | ACW > 5 MIN | 6906420 | 46331 | 20:15:00 | no | Other | 2011-06-01 00:00:00 | 05:46:00 | WCSE
[NAME] | Rand Hujeir | AUX >2 MIN | 6925110 | 46754 | 20:38:00 | no | Switched States | 2011-06-01 00:00:00 | 06:31:00 | WCBB
Maxime Nivose | [NAME] | ACW > 5 MIN | 8425950 | 46784 | 20:46:00 | no | Forgot on ACW/AUX | 2011-06-01 00:00:00 | 07:31:00 | WCBB
[NAME] | Sophie Normand | ACW > 5 MIN | 3106080 | 46492 | 21:20:00 | no | Tech Issue | 2011-06-01 00:00:00 | 06:32:00 | WCBB