Count if problem

[Joanna405]

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

[samba_ravi]

Assuming that Open / Closed status is in Column C

=COUNTIFS(C1:C12,"Open",C2:C13,"Closed")

Note: Find the Range selection deference in the formula

[Joanna405]

Thank you very much