Spreadsheet: 154553d1336484682-sumproduct-countif-being-very-slow-and-crashing-to-edit22
Sheet: Cat2

Email address | Date | SCORE | The advisor's attitude | The advisor's expertise in [NAME] products | The advisor's understanding of your query | TEXT | Category | Type | Action done | Incident #
email address | 18/04/2012 12:07 PM | 7 | 3 | 3 | 1
email address | 18/04/2012 01:03 PM | 15 | 5 | 5 | 5 | text
email address | 18/04/2012 05:59 PM | 16 | 5 | 4 | 4 | text
email address | 18/04/2012 10:40 AM | 8 | 4 | 3 | 1 | text
email address | 18/04/2012 02:02 PM | 5 | 3 | 1 | 1 | text
email address | 18/04/2012 07:42 PM | 5 | 3 | 1 | 1 | text
email address | 18/04/2012 09:24 PM | 18 | 4 | 4 | 5
email address | 18/04/2012 10:41 PM | 5 | 1 | 3 | 1 | text
email address | 18/04/2012 09:04 PM | 3 | 1 | 1 | 1 | text
email address | 18/04/2012 11:22 AM | 14 | 4 | 4 | 3 | text
email address | 18/04/2012 08:49 AM | 11 | 5 | 5 | 1 | text
email address | 18/04/2012 04:14 PM | 8 | 1 | 1 | 1 | text
email address | 18/04/2012 07:37 PM | 3 | 1 | 1 | 1 | text
email address | [NAME] 08:12 PM | 3 | 1 | 1 | 1 | text
email address | 18/04/2012 07:12 AM | 15 | 4 | 4 | 4 | text
email address | 18/04/2012 05:49 PM | 20 | 5 | 5 | 5
email address | 18/04/2012 03:51 PM | 20 | 5 | 5 | 5
email address | 18/04/2012 09:07 PM | 14 | 4 | 1 | 4 | text
email address | 18/04/2012 12:18 PM | 17 | 4 | 4 | 4
email address | 18/04/2012 09:56 AM | 3 | 1 | 1 | 1 | text
email address | 19/04/2012 03:41 PM | 3 | 1 | 1 | 1 | text
email address | 19/04/2012 04:56 AM | 3 | 1 | 1 | 1 | text
email address | 19/04/2012 08:24 PM | 3 | 1 | 1 | 1 | text
email address | 19/04/2012 10:18 AM | 20 | 5 | 5 | 5
email address | 19/04/2012 08:16 PM | 14 | 3 | 3 | 3
email address | 19/04/2012 03:28 AM | 11 | 3 | 4 | 4 | text
email address | 19/04/2012 06:59 PM | 5 | 1 | 3 | 1 | text
email address | 19/04/2012 03:47 PM | 17 | 4 | 4 | 4 | text
email address | 19/04/2012 07:48 PM | 3 | 1 | 1 | 1 | text
email address | 19/04/2012 02:23 PM | 17 | 4 | 4 | 4
email address | 19/04/2012 11:01 AM | 3 | 1 | 1 | 1
email address | 19/04/2012 09:24 PM | 20 | 5 | 5 | 5 | text
email address | 19/04/2012 10:11 AM | 16 | 5 | 5 | 3 | text
email address | 19/04/2012 11:30 AM | 3 | 1 | 1 | 1 | text
email address | 19/04/2012 12:33 PM | 20 | 5 | 5 | 5
email address | 19/04/2012 03:34 PM | 3 | 1 | 1 | 1 | text
email address | 19/04/2012 08:18 PM | 14 | 3 | 3 | 3 | text
email address | 19/04/2012 04:42 PM | 9 | 3 | 3 | 3 | text
email address | 19/04/2012 10:37 AM | 20 | 5 | 5 | 5
email address | 20/04/2012 08:25 PM | 3 | 1 | 1 | 1 | text
email address | 20/04/2012 09:29 AM | 20 | 5 | 5 | 5 | text
email address | 20/04/2012 01:02 PM | 3 | 1 | 1 | 1 | text
email address | 20/04/2012 08:33 AM | 3 | 1 | 1 | 1 | text
email address | 20/04/2012 04:38 PM | 3 | 1 | 1 | 1 | text
email address | 20/04/2012 09:47 AM | 20 | 5 | 5 | 5
email address | 20/04/2012 01:44 PM | 9 | 2 | 2 | 2 | text
email address | 20/04/2012 12:45 PM | 17 | 4 | 4 | 4 | text
email address | 20/04/2012 09:04 AM | 17 | 4 | 4 | 4
email address | 20/04/2012 03:18 PM | 3 | 1 | 1 | 1
email address | 20/04/2012 03:04 PM | 20 | 5 | 5 | 5 | text
email address | 20/04/2012 08:14 AM | 20 | 5 | 5 | 5
email address | 20/04/2012 03:45 PM | 7 | 1 | 2 | 1
email address | 20/04/2012 02:23 PM | 3 | 1 | 1 | 1 | text
email address | 20/04/2012 01:05 PM | 20 | 5 | 5 | 5
email address | 20/04/2012 05:05 AM | 15 | 5 | 2 | 5 | text
email address | 20/04/2012 03:59 PM | 9 | 3 | 3 | 3
email address | 20/04/2012 05:18 PM | 8 | 4 | 1 | 3 | text
email address | 20/04/2012 10:46 AM | 14 | 4 | 4 | 3 | text
email address | 20/04/2012 11:43 AM | 12 | 3 | 3 | 3 | text
email address | 20/04/2012 10:35 AM | 3 | 1 | 1 | 1
email address | 20/04/2012 11:39 AM | 3 | 1 | 1 | 1 | text
email address | 20/04/2012 11:40 AM | 20 | 5 | 5 | 5
email address | 20/04/2012 09:01 AM | 3 | 1 | 1 | 1 | text
email address | 20/04/2012 01:36 AM | 20 | 5 | 5 | 5 | text
email address | 21/04/2012 09:21 AM | 7 | 4 | 2 | 1 | text
email address | 21/04/2012 12:18 PM | 6 | 3 | 2 | 1 | text
email address | 21/04/2012 11:32 AM | 20 | 5 | 5 | 5
email address | 21/04/2012 02:47 PM | 3 | 1 | 1 | 1 | text
email address | 21/04/2012 06:15 PM | 3 | 1 | 1 | 1 | text
email address | 21/04/2012 02:46 PM | 3 | 1 | 1 | 1 | text
email address | 21/04/2012 02:00 PM | 15 | 4 | 4 | 4 | text
email address | 21/04/2012 03:08 PM | 15 | 5 | 5 | 5 | text
email address | 21/04/2012 12:53 PM | 20 | 5 | 5 | 5 | text
email address | 21/04/2012 10:37 AM | 3 | 1 | 1 | 1 | text
email address | 21/04/2012 10:25 AM | 20 | 5 | 5 | 5 | text
email address | 21/04/2012 10:16 AM | 3 | 1 | 1 | 1 | text
email address | 22/04/2012 04:38 PM | 3 | 1 | 1 | 1
email address | 22/04/2012 11:47 AM | 3 | 1 | 1 | 1 | text
email address | 22/04/2012 12:29 AM | 3 | 1 | 1 | 1 | text
email address | 22/04/2012 08:00 PM | 18 | 4 | 4 | 5
email address | 22/04/2012 06:30 PM | 9 | 3 | 3 | 3 | text
email address | 22/04/2012 11:01 AM | 19 | 5 | 4 | 5
email address | 22/04/2012 11:45 AM | 3 | 1 | 1 | 1 | text |  |  | email replied
email address | 22/04/2012 09:43 AM | 20 | 5 | 5 | 5
email address | 22/04/2012 07:46 PM | 17 | 4 | 4 | 4
email address | 22/04/2012 02:07 PM | 12 | 4 | 4 | 1 | text |  |  | email sent by the staff
email address | 22/04/2012 01:41 PM | 15 | 3 | 3 | 4
email address | 23/04/2012 03:23 PM | 3 | 1 | 1 | 1 | text
email address | 23/04/2012 10:01 PM | 3 | 1 | 1 | 1 | text
email address | 23/04/2012 05:36 AM | 13 | 3 | 3 | 4 | text
email address | 23/04/2012 05:30 AM | 20 | 5 | 5 | 5
email address | 23/04/2012 05:19 PM | 11 | 4 | 3 | 4
email address | 23/04/2012 02:04 PM | 20 | 5 | 5 | 5
email address | 23/04/2012 12:11 AM | 20 | 5 | 5 | 5
email address | 23/04/2012 05:49 PM | 20 | 5 | 5 | 5 | text
email address | 23/04/2012 01:48 PM | 3 | 1 | 1 | 1
email address | 23/04/2012 01:44 PM | 10 | 5 | 3 | 2 | text
email address | 23/04/2012 12:06 AM | 18 | 4 | 4 | 5
email address | 23/04/2012 07:23 PM | 20 | 5 | 5 | 5 | text
email address | 24/04/2012 01:08 PM | 3 | 1 | 1 | 1 | text
email address | 24/04/2012 06:47 PM | 3 | 1 | 1 | 1 | text
email address | 24/04/2012 12:45 PM | 10 | 1 | 1 | 3 | text
email address | 24/04/2012 03:48 PM | 20 | 5 | 5 | 5 | text
email address | 24/04/2012 05:05 PM | 20 | 5 | 5 | 5
email address | 24/04/2012 10:43 AM | 20 | 5 | 5 | 5
email address | 24/04/2012 11:43 AM | 14 | 4 | 4 | 3
email address | 24/04/2012 11:36 PM | 20 | 5 | 5 | 5 | text
email address | 24/04/2012 06:37 PM | 3 | 1 | 1 | 1 | text
email address | 24/04/2012 10:48 PM | 20 | 5 | 5 | 5 | text
email address | 24/04/2012 01:06 PM | 8 | 2 | 3 | 3 | text
email address | 24/04/2012 10:13 AM | 20 | 5 | 5 | 5
email address | 24/04/2012 08:36 PM | 17 | 4 | 4 | 4 | text
email address | 24/04/2012 10:12 PM | 14 | 3 | 3 | 3 | text
email address | 24/04/2012 11:06 AM | 14 | 3 | 3 | 3
email address | 24/04/2012 01:17 PM | 20 | 5 | 5 | 5
email address | 25/04/2012 12:50 PM | 7 | 2 | 4 | 1 | text | No
email address | [NAME] 06:46 PM | 20 | 5 | 5 | 5 |  | Yes
email address | 25/04/2012 12:33 AM | 20 | 5 | 5 | 5 | text | Yes
email address | 25/04/2012 09:30 PM | 18 | 4 | 4 | 5 |  | Yes
email address | 25/04/2012 10:01 AM | 3 | 1 | 1 | 1 | text | No
email address | 25/04/2012 02:03 PM | 20 | 5 | 5 | 5 |  | Yes
email address | 25/04/2012 09:05 AM | 10 | 4 | 4 | 2 | text | No
email address | 25/04/2012 09:36 AM | 14 | 3 | 3 | 3 | text | Yes
email address | 25/04/2012 02:44 PM | 3 | 1 | 1 | 1 | text | No
email address | 25/04/2012 12:58 AM | 18 | 5 | 3 | 5 | text | Yes
email address | 25/04/2012 10:43 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 25/04/2012 06:57 PM | 17 | 4 | 5 | 5 | text | Partially
email address | 25/04/2012 10:15 PM | 14 | 3 | 3 | 3 | text | Yes
email address | 25/04/2012 01:00 AM | 20 | 5 | 5 | 5 |  | Yes
email address | 25/04/2012 04:52 PM | 7 | 3 | 1 | 3 | text | No
email address | 25/04/2012 03:45 PM | 8 | 1 | 1 | 1 | text | Yes
email address | 25/04/2012 03:18 PM | 20 | 5 | 5 | 5 |  | Yes
email address | 25/04/2012 12:16 PM | 3 | 1 | 1 | 1 | text | No
email address | 25/04/2012 04:57 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 25/04/2012 10:26 PM | 6 | 2 | 2 | 2 | text | No
email address | 25/04/2012 07:40 AM | 20 | 5 | 5 | 5 | text | Yes
email address | 26/04/2012 11:20 AM | 20 | 5 | 5 | 5 | text | Yes
email address | 26/04/2012 10:58 AM | 16 | 5 | 5 | 3 |  | Partially
email address | 26/04/2012 11:59 AM | 20 | 5 | 5 | 5 | text | Yes
email address | 26/04/2012 05:45 AM | 20 | 5 | 5 | 5 |  | Yes
email address | 26/04/2012 09:29 PM | 20 | 5 | 5 | 5 |  | Yes
email address | 26/04/2012 08:20 PM | 17 | 4 | 4 | 4 |  | Yes
email address | 26/04/2012 11:38 PM | 3 | 1 | 1 | 1 |  | No
email address | 26/04/2012 12:11 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 26/04/2012 12:40 PM | 3 | 1 | 1 | 1 | text | No
email address | 26/04/2012 07:03 AM | 3 | 1 | 1 | 1 | text | No
email address | 26/04/2012 05:45 PM | 3 | 1 | 1 | 1 |  | No
email address | 26/04/2012 08:16 PM | 13 | 3 | 3 | 4 | text | Partially
email address | 26/04/2012 11:42 AM | 3 | 1 | 1 | 1 | text | No
email address | 26/04/2012 10:05 AM | 8 | 1 | 1 | 1 | text | Yes
email address | 26/04/2012 05:26 PM | 8 | 5 | 2 | 1 | text | No
email address | 26/04/2012 07:36 PM | 10 | 2 | 2 | 1 | text | Yes
email address | 26/04/2012 03:13 PM | 16 | 5 | 5 | 3 | text | Partially
email address | 26/04/2012 09:55 AM | 19 | 5 | 4 | 5 | text | Yes
email address | 26/04/2012 04:14 PM | 15 | 5 | 4 | 3 | text | Partially
email address | 26/04/2012 07:08 AM | 10 | 5 | 3 | 2 | text | No
email address | 26/04/2012 02:16 PM | 6 | 2 | 2 | 2 |  | No
email address | 26/04/2012 08:34 PM | 3 | 1 | 1 | 1 | text | No
email address | 26/04/2012 11:05 AM | 20 | 5 | 5 | 5 |  | Yes
email address | 26/04/2012 01:27 PM | 6 | 1 | 1 | 1 | text | Partially
email address | 26/04/2012 11:05 AM | 10 | 4 | 3 | 3 | text | No
email address | 26/04/2012 11:18 AM | 3 | 1 | 1 | 1 | text | No
email address | 27/04/2012 12:35 PM | 19 | 4 | 5 | 5 | text | Yes
email address | 27/04/2012 06:39 PM | 13 | 4 | 4 | 2 | text | Partially
email address | 27/04/2012 06:00 PM | 12 | 4 | 4 | 4 | text | No
email address | 27/04/2012 07:02 AM | 20 | 5 | 5 | 5 |  | Yes
email address | 27/04/2012 11:59 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 27/04/2012 07:58 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 27/04/2012 12:14 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 27/04/2012 09:59 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 27/04/2012 11:33 AM | 20 | 5 | 5 | 5 |  | Yes
email address | 27/04/2012 09:10 AM | 9 | 4 | 1 | 1 | text | Partially
email address | 27/04/2012 04:49 PM | 3 | 1 | 1 | 1 | text | No
email address | 27/04/2012 09:21 PM | 5 | 3 | 1 | 1 |  | No
email address | 27/04/2012 01:26 PM | 15 | 4 | 4 | 4 |  | Partially
email address | 28/04/2012 12:12 AM | 10 | 2 | 2 | 3 | text | Partially
email address | 28/04/2012 05:15 PM | 20 | 5 | 5 | 5 |  | Yes
email address | 28/04/2012 08:29 PM | 9 | 4 | 4 | 1 | text | No
email address | 28/04/2012 05:27 AM | 19 | 4 | 5 | 5 | text | Yes
email address | 29/04/2012 04:21 PM | 20 | 5 | 5 | 5 |  | Yes
email address | 29/04/2012 07:22 PM | 10 | 4 | 2 | 1 | text | Partially
email address | 29/04/2012 08:39 AM | 3 | 1 | 1 | 1 | text | No
email address | 29/04/2012 01:34 PM | 10 | 4 | 3 | 3 | text | No
email address | 29/04/2012 07:55 PM | 17 | 4 | 4 | 4 |  | Yes
email address | 29/04/2012 03:36 PM | 16 | 3 | 5 | 3 |  | Yes
email address | 29/04/2012 10:46 AM | 20 | 5 | 5 | 5 | text | Yes
email address | 29/04/2012 03:19 PM | 11 | 4 | 2 | 2 | text | Partially
email address | 29/04/2012 10:17 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 29/04/2012 12:10 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 29/04/2012 01:36 PM | 8 | 4 | 2 | 2 | text | No
email address | 30/04/2012 11:57 AM | 3 | 1 | 1 | 1 | text | No
email address | 30/04/2012 10:42 AM | 3 | 1 | 1 | 1 | text | No
email address | 30/04/2012 01:54 PM | 12 | 3 | 3 | 3 |  | Partially
email address | 30/04/2012 11:27 AM | 20 | 5 | 5 | 5 | text | Yes
email address | 30/04/2012 09:46 PM | 20 | 5 | 5 | 5 |  | Yes
email address | 30/04/2012 10:20 AM | 3 | 1 | 1 | 1 | text | No
email address | 30/04/2012 11:14 AM | 7 | 3 | 3 | 1 | text | No
email address | 30/04/2012 07:14 PM | 12 | 3 | 3 | 3 |  | Partially
email address | 30/04/2012 06:56 AM | 3 | 1 | 1 | 1 | text | No
email address | 30/04/2012 02:44 AM | 11 | 2 | 2 | 2 | text | Yes
email address | 01/05/2012 09:49 AM | 8 | 1 | 3 | 1 | text | Partially
email address | 01/05/2012 03:52 PM | 20 | 5 | 5 | 5 |  | Yes
email address | 01/05/2012 03:40 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 01/05/2012 09:47 AM | 20 | 5 | 5 | 5 | text | Yes
email address | 01/05/2012 03:03 PM | 14 | 3 | 3 | 5 |  | Partially
email address | 01/05/2012 09:27 PM | 18 | 5 | 5 | 5 |  | Partially
email address | 01/05/2012 06:43 PM | 17 | 3 | 4 | 5 |  | Yes
email address | 01/05/2012 10:44 PM | 12 | 3 | 3 | 3 |  | Partially
email address | 01/05/2012 05:53 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 01/05/2012 12:26 AM | 11 | 3 | 4 | 4 | text | No
email address | 01/05/2012 09:49 AM | 8 | 1 | 3 | 1 | text | Partially
email address | 01/05/2012 03:52 PM | 20 | 5 | 5 | 5 |  | Yes
email address | 01/05/2012 03:40 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 01/05/2012 09:47 AM | 20 | 5 | 5 | 5 | text | Yes
email address | 01/05/2012 03:03 PM | 14 | 3 | 3 | 5 |  | Partially
email address | 01/05/2012 09:27 PM | 18 | 5 | 5 | 5 |  | Partially
email address | 01/05/2012 06:43 PM | 17 | 3 | 4 | 5 |  | Yes
email address | 01/05/2012 10:44 PM | 12 | 3 | 3 | 3 |  | Partially
email address | 01/05/2012 05:53 PM | 20 | 5 | 5 | 5 | text | Yes
email address | 01/05/2012 12:26 AM | 11 | 3 | 4 | 4 | text | No