honestabe1982
New Member
- Joined
- Aug 30, 2017
- Messages
- 3
Please see the spreadsheet below. I've tried multiple array formulas with combination of sum/sumproduct/if/countif and no luck. I am trying to count the number of distinct ANI's that have a call time of greater than 0:00:29 and are of the campaign, Inbound - Live TV5.
I've been at this for hours using examples from other posts and no luck so far.
Please help.
Thanks!
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I've been at this for hours using examples from other posts and no luck so far.
Please help.
Thanks!
TIMESTAMP | ANI | CALL TIME | CAMPAIGN |
Mon, 28 Aug 2017 12:04:10 | 2014515824 | 0:08:40 | Inbound - Double Verified 4 |
Mon, 28 Aug 2017 09:16:49 | 2022626840 | 0:00:10 | Inbound - Live TV4 |
Mon, 28 Aug 2017 12:32:29 | 2022765447 | 0:01:28 | Inbound - Live TV4 |
Mon, 28 Aug 2017 19:05:51 | 2024760812 | 0:00:09 | Inbound - Live TV4 |
Tue, 29 Aug 2017 15:41:02 | 2025621775 | 0:05:13 | Inbound - Internet Lead |
Tue, 29 Aug 2017 13:06:08 | 2028295219 | 1:03:57 | Inbound - Double Verified 4 |
Mon, 28 Aug 2017 12:32:37 | 2055524685 | 0:01:19 | Inbound - Live TV4 |
Mon, 28 Aug 2017 11:33:15 | 2062940772 | 0:01:53 | Inbound - Live TV4 |
Mon, 28 Aug 2017 12:33:16 | 2064878245 | 0:13:12 | Inbound - Live TV4 |
Tue, 29 Aug 2017 11:52:23 | 2066641724 | 1:09:33 | Inbound - Live TV4 |
Tue, 29 Aug 2017 17:47:53 | 2092022265 | 0:00:05 | Inbound - Live TV5 |
Mon, 28 Aug 2017 16:38:45 | 2093126143 | 0:01:32 | Inbound - Internet Lead |
Tue, 29 Aug 2017 12:47:25 | 2093457470 | 0:16:44 | Inbound - Live TV4 |
Tue, 29 Aug 2017 13:56:05 | 2095672847 | 1:44:50 | Inbound - Live TV4 |
Tue, 29 Aug 2017 13:13:37 | 2097285517 | 0:02:59 | Inbound - Live TV4 |
Tue, 29 Aug 2017 12:53:15 | 2098269164 | 0:15:18 | Inbound - Live TV5 |
Tue, 29 Aug 2017 17:48:59 | 2098292391 | 0:00:37 | Inbound - Live TV5 |
Tue, 29 Aug 2017 17:55:18 | 2098292391 | 0:00:22 | Inbound - Live TV5 |
Mon, 28 Aug 2017 13:25:07 | 2098298832 | 0:04:54 | Inbound - Live TV4 |
Tue, 29 Aug 2017 16:33:03 | 2103070396 | 1:36:38 | Inbound - Live TV4 |
Mon, 28 Aug 2017 13:21:23 | 2103153053 | 1:22:14 | Inbound - Live TV5 |
Mon, 28 Aug 2017 11:34:40 | 2103332978 | 1:18:00 | Inbound - Live TV4 |
Tue, 29 Aug 2017 16:15:40 | 2103866212 | 0:01:17 | Inbound - Live TV4 |
Mon, 28 Aug 2017 16:57:16 | 2104101834 | 0:02:55 | Inbound - Live TV4 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>