Hi,

I need to count the "closed" word only if is after "open". It should count 5 "closed".
Can anyone help me with a formula for it, please? Thanks


2018-05-21 10:42:31 Closed
2018-05-21 10:32:31 Closed
2018-05-21 10:26:27 Closed
2018-05-21 10:26:23 Open
2018-05-21 10:26:22 Closed
2018-05-21 10:26:17 Open
2018-05-21 10:25:49 Closed
2018-05-21 10:25:31 Open
2018-05-21 10:22:31 Closed
2018-05-21 10:21:33 Closed
2018-05-21 10:21:00 Open
2018-05-21 10:20:51 Closed
2018-05-21 10:20:46 Open