Spreadsheet: 846153d1697455234-countif-and-sumif-forumla-help-needed-cobraheart
Sheet: All

[NAME] Campaign | Type | Activity Type | Brand | Send List | Date | Year | Month | Week | Day of Week | Time | Total Delivered | Unique Opens | Open Rate | Total Clicks | Contacts Clicked | CTR% | CTOR%
Campaign 1 | Event | Running | Planters | Active | 2023-01-01 19:02:00 | 2023-01-01 19:02:00 | 2023-01-01 19:02:00 | 38 | Wednesday | 2023-01-01 19:02:00 | 34789 | 15840 |  | 453 | 182
Campaign 2 | Blog | Running | Planters | Active | 2023-02-22 16:31:00 | 2023-02-22 16:31:00 | 2023-02-22 16:31:00 | 38 | Friday | 2023-02-22 16:31:00 | 33806 | 20821 |  | 661 | 458
Campaign 3 | Content | Running | Planters | Active | 2023-03-25 19:02:00 | 2023-03-25 19:02:00 | 2023-03-25 19:02:00 | 38 | Monday | 2023-03-25 19:02:00 | 26425 | 16245 |  | 613 | 306
Campaign 4 | Event | Running | Planters | Active | 2023-04-26 19:00:00 | 2023-04-26 19:00:00 | 2023-04-26 19:00:00 | 39 | Tuesday | 2023-04-26 19:00:00 | 25626 | 15693 |  | 453 | 328
Campaign 5 | Blog | Running | Planters | Active | 2023-05-27 19:03:00 | 2023-05-27 19:03:00 | 2023-05-27 19:03:00 | 39 | Wednesday | 2023-05-27 19:03:00 | 25603 | 15840 |  | 661 | 358
Campaign 6 | Content | Running | Planters | Active | 2023-06-29 16:31:00 | 2023-06-29 16:31:00 | 2023-06-29 16:31:00 | 39 | Friday | 2023-06-29 16:31:00 | 33806 | 20821 |  | 613 | 182
Campaign 7 | Event | Running | Planters | Active | 2023-05-24 19:00:00 | 2023-05-24 19:00:00 | 2023-05-24 19:00:00 | 34 | Thursday | 2023-05-24 19:00:00 | 26425 | 16245 |  | 638 | 458
Campaign 8 | Blog | Running | Planters | Active | 2021-07-09 19:15:00 | 2021-07-09 19:15:00 | 2021-07-09 19:15:00 | 52 | Monday | 2021-07-09 19:15:00 | 25626 | 15693 |  | 690 | 306
Campaign 9 | Content | Running | Planters | Active | 2023-01-15 10:31:00 | 2023-01-15 10:31:00 | 2023-01-15 10:31:00 | 52 | Sunday | 2023-01-15 10:31:00 | 25603 | 15422 |  | 1128 | 328
Campaign 10 | Event | Running | Planters | Active | 2022-12-04 08:32:00 | 2022-12-04 08:32:00 | 2022-12-04 08:32:00 | 52 | Wednesday | 2022-12-04 08:32:00 | 28874 | 17162 |  | 400 | 358
Campaign 11 | Blog | Running | Planters | Active | 2022-09-26 11:30:00 | 2022-09-26 11:30:00 | 2022-09-26 11:30:00 | 52 | Friday | 2022-09-26 11:30:00 | 27695 | 16362 |  | 16 | 955
Campaign 12 | Content | Running | Planters | Active | 2022-08-20 20:01:00 | 2022-08-20 20:01:00 | 2022-08-20 20:01:00 | 52 | Monday | 2022-08-20 20:01:00 | 25612 | 15179 |  | 589 | 233
Campaign 13 | Event | Running | Planters | Active | 2023-02-05 10:31:00 | 2023-02-05 10:31:00 | 2023-02-05 10:31:00 | 52 | Tuesday | 2023-02-05 10:31:00 | 33806 | 20821 |  | 453 | 182
Campaign 14 | Blog | Running | Planters | Active | 2022-04-11 20:01:00 | 2022-04-11 20:01:00 | 2022-04-11 20:01:00 | 52 | Wednesday | 2022-04-11 20:01:00 | 26425 | 16245 |  | 661 | 458
Campaign 15 | Event | Running | Planters | Active | 2022-08-15 19:01:00 | 2022-08-15 19:01:00 | 2022-08-15 19:01:00 | 52 | Friday | 2022-08-15 19:01:00 | 25626 | 15693 |  | 613 | 306
Campaign 16 | Blog | Running | Planters | Active | 2022-09-01 10:02:00 | 2022-09-01 10:02:00 | 2022-09-01 10:02:00 | 52 | Thursday | 2022-09-01 10:02:00 | 25603 | 15422 |  | 638 | 328
Campaign 17 | Content | Running | Planters | Active | 2022-09-10 20:01:00 | 2022-09-10 20:01:00 | 2022-09-10 20:01:00 | 52 | Monday | 2022-09-10 20:01:00 | 28874 | 17162 |  | 690 | 358
Campaign 18 | Event | Running | Planters | Active | 2022-05-03 08:05:00 | 2022-05-03 08:05:00 | 2022-05-03 08:05:00 | 52 | Sunday | 2022-05-03 08:05:00 | 27695 | 16362 |  | 1128 | 955
Campaign 19 | Blog | Running | Planters | Active | 2022-06-23 18:05:00 | 2022-06-23 18:05:00 | 2022-06-23 18:05:00 | 52 | Monday | 2022-06-23 18:05:00 | 25697 | 15179 |  | 400 | 233