Spreadsheet: 726538d1617287000-help-with-complex-formula-count-value-if-criteria-met-programdata-ans
Sheet: Data

Year | Category | Subcategory | Month | Value
2015 | Activity | Courses | January | 30 |  |  |  |  |  | Year | Month
2015 | Activity | EM - Internet | January | 9
2015 | Activity | Internet Live Course | January | 0
2015 | Activity | Internet S&L | January | 0
2015 | Activity | Journal CME | January | 0 |  |  |  |  |  | 2018 | January
2015 | Activity | JP Courses | January | 8 |  |  |  |  |  | 2020 | February
2015 | Activity | JP RSSs | January | 5 |  |  |  |  |  | 2015 | March
2015 | Activity | NA Courses | January | 0
2015 | Activity | [NAME] | January | 0
2015 | Activity | Other | January | 0
2015 | Activity | PI CME | January | 0
2015 | Activity | RSSs | January | 57
2015 | Program | Active Users | January | 0
2015 | Program | Credits Awarded | January | 0
2015 | Program | Evaluations | January | 0
2015 | Program | System Users | January | 0
2016 | Activity | Courses | January | 34
2016 | Activity | EM - Internet | January | 19
2016 | Activity | Internet Live Course | January | 0
2016 | Activity | Internet S&L | January | 0
2016 | Activity | Journal CME | January | 0
2016 | Activity | JP Courses | January | 3
2016 | Activity | JP RSSs | January | 4
2016 | Activity | NA Courses | January | 0
2016 | Activity | [NAME] | January | 0
2016 | Activity | Other | January | 0
2016 | Activity | PI CME | January | 0
2016 | Activity | RSSs | January | 54
2016 | Program | Active Users | January | 0
2016 | Program | Credits Awarded | January | 0
2016 | Program | Evaluations | January | 0
2016 | Program | System Users | January | 0
2017 | Activity | Courses | January | 49
2017 | Activity | EM - Internet | January | 29
2017 | Activity | Internet Live Course | January | 0
2017 | Activity | Internet S&L | January | 0
2017 | Activity | Journal CME | January | 0
2017 | Activity | JP Courses | January | 5
2017 | Activity | JP RSSs | January | 4
2017 | Activity | NA Courses | January | 0
2017 | Activity | [NAME] | January | 0
2017 | Activity | Other | January | 0
2017 | Activity | PI CME | January | 0
2017 | Activity | RSSs | January | 61
2017 | Program | Active Users | January | 0
2017 | Program | Credits Awarded | January | 0
2017 | Program | Evaluations | January | 0
2017 | Program | System Users | January | 0
2017 | CloudCME | Tickets | December | 2
2018 | Activity | Courses | January | 73
2018 | Activity | EM - Internet | January | 44
2018 | Activity | Internet Live Course | January | 0
2018 | Activity | Internet S&L | January | 0
2018 | Activity | Journal CME | January | 0
2018 | Activity | JP Courses | January | 5
2018 | Activity | JP RSSs | January | 2
2018 | Activity | NA Courses | January | 0
2018 | Activity | [NAME] | January | 0
2018 | Activity | Other | January | 0
2018 | Activity | PI CME | January | 0
2018 | Activity | RSSs | January | 78
2018 | CloudCME | Tickets | January | 8
2018 | Program | Active Users | January | 2724
2018 | Program | Credits Awarded | January | 27261
2018 | Program | Evaluations | January | 1113
2018 | Program | System Users | January | 18973
2018 | CloudCME | Tickets | February | 0
2018 | CloudCME | Tickets | March | 14
2018 | CloudCME | Tickets | April | 15
2018 | CloudCME | Tickets | May | 18
2018 | CloudCME | Tickets | June | 14
2018 | CloudCME | Tickets | July | 13
2018 | CloudCME | Tickets | August | 9
2018 | CloudCME | Tickets | September | 15
2018 | CloudCME | Tickets | October | 15
2018 | CloudCME | Tickets | November | 19
2018 | CloudCME | Tickets | December | 11
2019 | Activity | Courses | January | 5
2019 | Activity | EM - Internet | January | 11
2019 | Activity | Internet Live Course | January | 0
2019 | Activity | Internet S&L | January | 0
2019 | Activity | Journal CME | January | 0
2019 | Activity | JP RSSs | January | 2
2019 | Activity | [NAME] | January | 0
2019 | Activity | PI CME | January | 1
2019 | Activity | RSSs | January | 53
2019 | CloudCME | Tickets | January | 11
2019 | Program | Active Users | January | 727
2019 | Program | Credits Awarded | January | 2248.75
2019 | Program | Evaluations | January | 332
2019 | Program | System Users | January | 100
2019 | Activity | Courses | February | 9
2019 | Activity | JP RSSs | February | 1
2019 | Activity | RSSs | February | 10
2019 | CloudCME | Tickets | February | 17
2019 | Program | Active Users | February | 1081
2019 | Program | Credits Awarded | February | 2734
2019 | Program | Evaluations | February | 392
2019 | Program | System Users | February | 495
2019 | Activity | Courses | March | 2
2019 | Activity | RSSs | March | 4
2019 | CloudCME | Tickets | March | 12
2019 | Program | Active Users | March | 831
2019 | Program | Credits Awarded | March | 3337.5
2019 | Program | Evaluations | March | 668
2019 | Program | System Users | March | 177
2019 | Activity | Courses | April | 4
2019 | Activity | RSSs | April | 2
2019 | CloudCME | Tickets | April | 13
2019 | Program | Active Users | April | 874
2019 | Program | Credits Awarded | April | 4970.25
2019 | Program | Evaluations | April | 382
2019 | Program | System Users | April | 173
2019 | Activity | Courses | May | 2
2019 | Activity | JP Courses | May | 1
2019 | CloudCME | Tickets | May | 9
2019 | Program | Active Users | May | 940
2019 | Program | Credits Awarded | May | 6766
2019 | Program | Evaluations | May | 789
2019 | Program | System Users | May | 249
2019 | Activity | Courses | June | 1
2019 | Activity | RSSs | June | 1
2019 | CloudCME | Tickets | June | 6
2019 | Program | Active Users | June | 507
2019 | Program | Credits Awarded | June | 1093.5
2019 | Program | Evaluations | June | 298
2019 | Program | System Users | June | 70
2019 | Activity | Courses | July | 6
2019 | Activity | Other | July | 1
2019 | Activity | RSSs | July | 1
2019 | CloudCME | Tickets | July | 11
2019 | Program | Active Users | July | 664
2019 | Program | Credits Awarded | July | 1679.9
2019 | Program | Evaluations | July | 229
2019 | Program | System Users | July | 82
2019 | Activity | Courses | August | 6
2019 | Activity | RSSs | August | 4
2019 | CloudCME | Tickets | August | 6
2019 | Program | Active Users | August | 613
2019 | Program | Credits Awarded | August | 1565.75
2019 | Program | Evaluations | August | 506
2019 | Program | System Users | August | 293
2019 | Activity | Courses | September | 6
2019 | Activity | JP Courses | September | 1
2019 | Activity | RSSs | September | 3
2019 | CloudCME | Tickets | September | 12
2019 | Program | Active Users | September | 710
2019 | Program | Credits Awarded | September | 2841.75
2019 | Program | Evaluations | September | 365
2019 | Program | System Users | September | 198
2019 | Activity | Courses | October | 8
2019 | Activity | EM - Internet | October | 2
2019 | Activity | JP Courses | October | 1
2019 | Activity | NA Courses | October | 1
2019 | Activity | RSSs | October | 4
2019 | CloudCME | Tickets | October | 9
2019 | Program | Active Users | October | 1271
2019 | Program | Credits Awarded | October | 8282.5
2019 | Program | Evaluations | October | 708
2019 | Program | System Users | October | 216
2019 | Activity | Courses | November | 4
2019 | Activity | EM - Internet | November | 2
2019 | Activity | RSSs | November | 1
2019 | CloudCME | Tickets | November | 7
2019 | Program | Active Users | November | 824
2019 | Program | Credits Awarded | November | 3683.65
2019 | Program | Evaluations | November | 440
2019 | Program | System Users | November | 114
2019 | Activity | Courses | December | 1
2019 | CloudCME | Tickets | December | 6
2019 | Program | Active Users | December | 519
2019 | Program | Credits Awarded | December | 1363.75
2019 | Program | Evaluations | December | 440
2019 | Program | System Users | December | 114
2020 | Activity | Courses | January | 7
2020 | Activity | EM - Internet | January | 15
2020 | Activity | Internet S&L | January | 0
2020 | Activity | Journal CME | January | 0
2020 | Activity | JP Courses | January | 0
2020 | Activity | JP RSSs | January | 1
2020 | Activity | NA Courses | January | 0
2020 | Activity | PI CME | January | 0
2020 | Activity | RSSs | January | 52
2020 | CloudCME | Tickets | January | 6
2020 | Program | Active Users | January | 1013
2020 | Program | Credits Awarded | January | 3156.25
2020 | Program | Evaluations | January | 1389
2020 | Program | System Users | January | 220
2020 | Activity | Courses | February | 7
2020 | Activity | EM - Internet | February | 1
2020 | Activity | Internet S&L | February | 0
2020 | Activity | RSSs | February | 19
2020 | CloudCME | Tickets | February | 17
2020 | Program | Active Users | February | 897
2020 | Program | Credits Awarded | February | 2571
2020 | Program | Evaluations | February | 724
2020 | Program | System Users | February | 51
2020 | Activity | Courses | March | 6
2020 | Activity | EM - Internet | March | 3
2020 | Activity | Internet S&L | March | 0
2020 | Activity | RSSs | March | 6
2020 | CloudCME | Tickets | March | 10
2020 | Program | Active Users | March | 588
2020 | Program | Credits Awarded | March | 2534
2020 | Program | Evaluations | March | 283
2020 | Program | System Users | March | 152
2020 | Activity | Courses | April | 1
2020 | Activity | EM - Internet | April | 6
2020 | Activity | Internet Live Course | April | 1
2020 | Activity | Internet S&L | April | 1
2020 | Activity | RSSs | April | 3
2020 | CloudCME | Tickets | April | 12
2020 | Program | Active Users | April | 656
2020 | Program | Credits Awarded | April | 2534
2020 | Program | Evaluations | April | 538
2020 | Program | System Users | April | 104
2020 | Activity | EM - Internet | May | 2
2020 | Activity | Internet Live Course | May | 1
2020 | Activity | Internet S&L | May | 0
2020 | Activity | RSSs | May | 2
2020 | CloudCME | Tickets | May | 5
2020 | Program | Active Users | May | 455
2020 | Program | Credits Awarded | May | 1315.5
2020 | Program | Evaluations | May | 122
2020 | Program | System Users | May | 59
2020 | Activity | EM - Internet | June | 2
2020 | Activity | Internet Live Course | June | 1
2020 | Activity | Internet S&L | June | 0
2020 | Activity | RSSs | June | 3
2020 | CloudCME | Tickets | June | 7
2020 | Program | Active Users | June | 501
2020 | Program | Credits Awarded | June | 1403
2020 | Program | Evaluations | June | 104
2020 | Program | System Users | June | 49
2020 | Activity | Courses | July | 1
2020 | Activity | EM - Internet | July | 2
2020 | Activity | Internet Live Course | July | 2
2020 | Activity | Internet S&L | July | 0
2020 | Activity | RSSs | July | 6
2020 | CloudCME | Tickets | July | 8
2020 | Program | Active Users | July | 589
2020 | Program | Credits Awarded | July | 1276.75
2020 | Program | Evaluations | July | 155
2020 | Program | System Users | July | 128
2020 | Activity | Courses | August | 1
2020 | Activity | EM - Internet | August | 4
2020 | Activity | Internet Live Course | August | 7
2020 | Activity | Internet S&L | August | 0
2020 | Activity | RSSs | August | 1
2020 | CloudCME | Tickets | August | 8
2020 | Program | Active Users | August | 802
2020 | Program | Credits Awarded | August | 1818.25
2020 | Program | Evaluations | August | 362
2020 | Program | System Users | August | 257
2020 | Activity | Courses | September | 1
2020 | Activity | EM - Internet | September | 6
2020 | Activity | Internet Live Course | September | 3
2020 | Activity | Internet S&L | September | 0
2020 | Activity | [NAME] | September | 3
2020 | Activity | RSSs | September | 6
2020 | CloudCME | Tickets | September | 17
2020 | Program | Active Users | September | 771
2020 | Program | Credits Awarded | September | 1932
2020 | Program | Evaluations | September | 289
2020 | Program | System Users | September | 580
2020 | Activity | EM - Internet | October | 8
2020 | Activity | Internet Live Course | October | 6
2020 | Activity | Internet S&L | October | 0
2020 | Activity | RSSs | October | 5
2020 | CloudCME | Tickets | October | 13
2020 | Program | Active Users | October | 1589
2020 | Program | Credits Awarded | October | 1719
2020 | Program | Evaluations | October | 2276
2020 | Program | System Users | October | 504
2020 | Activity | Courses | November | 2
2020 | Activity | EM - Internet | November | 3
2020 | Activity | Internet Live Course | November | 5
2020 | Activity | Internet S&L | November | 0
2020 | Activity | Other | November | 6
2020 | Activity | RSSs | November | 5
2020 | CloudCME | Tickets | November | 13
2020 | Program | Active Users | November | 990
2020 | Program | Credits Awarded | November | 2415.25
2020 | Program | Evaluations | November | 1864
2020 | Program | System Users | November | 22
2020 | Activity | Courses | December | 1
2020 | Activity | EM - Internet | December | 7
2020 | Activity | Internet Live Course | December | 4
2020 | Activity | Internet S&L | December | 0
2020 | CloudCME | Tickets | December | 5
2020 | Program | Active Users | December | 959
2020 | Program | Credits Awarded | December | 1068.25
2020 | Program | Evaluations | December | 1507
2020 | Program | System Users | December | 116
2021 | Activity | Courses | January | 52
2021 | Activity | EM - Internet | January | 5 |  |  |  |  | Year | Month
2021 | Activity | Internet Live Course | January | 0 |  |  |  |  |  |  | =Countif($A$297:$A$331,
2021 | Activity | Internet S&L | January | 0
2021 | Activity | Journal CME | January | 0
2021 | Activity | JP Courses | January | 0
2021 | Activity | JP RSSs | January | 1
2021 | Activity | NA Courses | January | 0
2021 | Activity | [NAME] | January | 3
2021 | Activity | Other | January | 0
2021 | Activity | PI CME | January | 0
2021 | Activity | RSSs | January | 53
2021 | CloudCME | Tickets | January | 11
2021 | Program | Active Users | January | 703
2021 | Program | Credits Awarded | January | 1840.75
2021 | Program | Evaluations | January | 1389
2021 | Program | System Users | January | 172
2021 | Activity | Courses | February | 0
2021 | Activity | EM - Internet | February | 0
2021 | Activity | Internet Live Course | February | 0
2021 | Activity | Internet S&L | February | 0
2021 | Activity | Journal CME | February | 0
2021 | Activity | JP Courses | February | 0
2021 | Activity | JP RSSs | February | 0
2021 | Activity | NA Courses | February | 0
2021 | Activity | [NAME] | February | 0
2021 | Activity | Other | February | 0
2021 | Activity | PI CME | February | 0
2021 | Activity | RSSs | February | 0
2021 | CloudCME | Tickets | February | 16
2021 | Program | Active Users | February | 0
2021 | Program | Credits Awarded | February | 0
2021 | Program | Evaluations | February | 0
2021 | Program | System Users | February | 0
2021 | CloudCME | Tickets | March | 1
2021 | Activity | Internet S&L | March | 47