Spreadsheet: 877790d1724708344-if-count-if-formula-help-test-doc
Sheet: Sheet1

First Name | [NAME] | Logout DTS | Dial Group
[NAME] | 16:59:00 | 17:14:00 | 1 |  |  |  | Login time | 17:14:00
[NAME] | 14:33:00 | 15:04:00 | 2
[NAME] | 13:50:00 | 14:20:00 | 2 |  |  |  | Dial Group | 1
[NAME] | 12:25:00 | 13:05:00 | 2
[NAME] | 16:56:00 | 17:14:00 | 3
[NAME] | 16:01:00 | 17:14:00 | 3
[NAME] | 16:59:00 | 17:14:00 | 1 |  |  |  | I WANT TO COUNT THE # OF LOG IN TIMES IN COLUMN C  THAT MATCHES THE TIME IN CELL I2… BUT I ONLY WANT TO COUNT THE ONES THAT MATCH CELL I4 IN COLUMN D
Capucine | 17:00:00 | 17:14:00 | 4
[NAME] | 16:56:00 | 17:14:00 | 3
Christine | 16:59:00 | 17:14:00 | 1
Jodi Lynn | 16:59:00 | 17:14:00 | 4
[NAME] | 17:05:00 | 17:14:00 | 5
[NAME] | 17:00:00 | 17:14:00 | 5
Michelle | 17:02:00 | 17:14:00 | 4
Kaila | 16:59:00 | 17:14:00 | 6
[NAME] | 17:00:00 | 17:14:00 | 7
[NAME] | 17:10:00 | 17:14:00 | 1
[NAME] | 16:58:00 | 17:10:00 | 1
[NAME] | 17:09:00 | 17:14:00 | 3
Jenesis | 17:07:00 | 17:14:00 | 4
Rubi | 17:11:00 | 17:14:00 | 7
Rubi | 17:04:00 | 17:10:00 | 7
[NAME] | 17:00:00 | 17:14:00 | 4
Nicole | 17:03:00 | 17:14:00 | 3
[NAME] | 17:00:00 | 17:14:00 | 1
Jan | 17:00:00 | 17:14:00 | 7
[NAME] | 16:59:00 | 17:14:00 | 4
Tapiwa | 17:02:00 | 17:14:00 | 7
Ruby | 17:01:00 | 17:14:00 | 7
Danette | 16:58:00 | 17:14:00 | 1
Samantha | 17:01:00 | 17:14:00 | 1
Samantha | 17:00:00 | 17:00:00 | 1
[NAME] | 17:00:00 | 17:14:00 | 4
Melisha | 17:00:00 | 17:14:00 | 1
Christina | 17:00:00 | 17:14:00 | 7
[NAME] | 17:03:00 | 17:14:00 | 5
[NAME] | 17:13:00 | 17:14:00 | 4
Nikole | 17:02:00 | 17:14:00 | 4
[NAME] | 17:01:00 | 17:14:00 | 5
[NAME] | 16:58:00 | 17:14:00 | 3
[NAME] | 17:00:00 | 17:14:00 | 3
[NAME] | 17:04:00 | 17:14:00 | 1
Leah | 17:01:00 | 17:14:00 | 6
Chakiya | 17:00:00 | 17:14:00 | 1
[NAME] | 17:10:00 | 17:14:00 | 7
[NAME] | 17:00:00 | 17:09:00 | 7
Sierra | 16:59:00 | 17:14:00 | 4
[NAME] | 17:01:00 | 17:14:00 | 4
Ruby | 17:08:00 | 17:14:00 | 1
Catena | 17:01:00 | 17:14:00 | 6
Munah | 17:06:00 | 17:14:00 | 4
Munah | 16:58:00 | 17:06:00 | 4
[NAME] | 17:00:00 | 17:14:00 | 7
[NAME] | 16:59:00 | 17:00:00 | 7
[NAME] | 17:01:00 | 17:14:00 | 5
Monserrat | 17:03:00 | 17:14:00 | 4
[NAME] | 17:01:00 | 17:14:00 | 6
[NAME] | 17:00:00 | 17:14:00 | 4
Adrena | 16:59:00 | 17:14:00 | 5
Jerchell | 17:00:00 | 17:14:00 | 1
Jerchell | 16:59:00 | 17:00:00 | 1
DeAnthony | 17:00:00 | 17:14:00 | 4
Prisilla | 17:02:00 | 17:14:00 | 7
[NAME] | 17:01:00 | 17:14:00 | 1
Trushonda | 16:59:00 | 17:14:00 | 6
Kyah | 17:06:00 | 17:14:00 | 1
Debora | 17:00:00 | 17:14:00 | 7
[NAME] | 17:04:00 | 17:14:00 | 1
[NAME] | 16:59:00 | 17:14:00 | 5
[NAME] | 17:03:00 | 17:14:00 | 5
Kayla | 16:59:00 | 17:14:00 | 1
Leah | 17:01:00 | 17:14:00 | 6
[NAME] | 17:00:00 | 17:14:00 | 5
Ingrid | 16:59:00 | 17:14:00 | 4
Kelly | 17:00:00 | 17:14:00 | 7
[NAME] | 17:00:00 | 17:14:00 | 6
[NAME] | 17:01:00 | 17:14:00 | 5
[NAME] | 17:00:00 | 17:14:00 | 4
Erinne | 17:10:00 | 17:14:00 | 4
Erinne | 17:05:00 | 17:09:00 | 4
Erinne | 17:02:00 | 17:04:00 | 4
Erinne | 17:01:00 | 17:01:00 | 4
Erinne | 17:00:00 | 17:01:00 | 4
Deonna | 17:01:00 | 17:14:00 | 5
Safiya | 17:00:00 | 17:14:00 | 4
Tami | 16:59:00 | 17:14:00 | 4
Timesha | 17:06:00 | 17:14:00 | 1
Scott | 17:00:00 | 17:14:00 | 5
Willis | 17:00:00 | 17:14:00 | 1
Victoria | 17:00:00 | 17:14:00 | 6
Marianne | 17:00:00 | 17:14:00 | 5
Nicole | 16:59:00 | 17:14:00 | 5
Callie | 16:58:00 | 17:14:00 | 4
Donia | 17:00:00 | 17:14:00 | 1
Sieria | 17:07:00 | 17:14:00 | 7
Belynda | 16:59:00 | 17:14:00 | 4
Briana | 17:10:00 | 17:14:00 | 6
[NAME] | 16:59:00 | 17:14:00 | 4
[NAME] | 16:59:00 | 17:14:00 | 7
[NAME] | 16:59:00 | 17:14:00 | 4
Onesha | 17:00:00 | 17:14:00 | 6
[NAME] | 17:04:00 | 17:14:00 | 4
Alissa | 16:58:00 | 17:14:00 | 4
Samantha | 16:59:00 | 17:14:00 | 6
Carrie | 17:11:00 | 17:14:00 | 6
[NAME] | 17:00:00 | 17:14:00 | 1
[NAME] | 17:02:00 | 17:14:00 | 4
[NAME] | 15:54:00 | 17:14:00 | 3
Erika | 17:00:00 | 17:14:00 | 4
Ky'Asha | 17:00:00 | 17:14:00 | 4
Marsha | 17:00:00 | 17:14:00 | 4
[NAME] | 17:02:00 | 17:14:00 | 5
[NAME] | 17:01:00 | 17:02:00 | 5
Kassandra | 17:00:00 | 17:14:00 | 6
[NAME] | 17:00:00 | 17:14:00 | 5
Ariana | 17:00:00 | 17:14:00 | 7
Essence | 17:01:00 | 17:14:00 | 6
Asia | 17:02:00 | 17:14:00 | 7
Deyanira | 17:01:00 | 17:14:00 | 6
Jordan | 17:02:00 | 17:14:00 | 4
[NAME] | 17:00:00 | 17:14:00 | 6
[NAME] | 16:59:00 | 16:59:00 | 6
[NAME] | 16:59:00 | 17:14:00 | 6