CountIfs how to

[FanofExcel18]

My Data

[TABLE="width: 423"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Sequence[/TD]
[TD]Date/Time[/TD]
[TD]Who[/TD]
[TD]What[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]1 [/TD]
[TD]10/1/18 2:41 PM[/TD]
[TD]John Smith[/TD]
[TD]Open*[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1 [/TD]
[TD]10/1/18 2:41 PM[/TD]
[TD]John Smith[/TD]
[TD]Edited[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]2 [/TD]
[TD]10/4/18 2:15 PM[/TD]
[TD]John Smith[/TD]
[TD]Open*[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD] 10/4/18 2:15 PM[/TD]
[TD]John Smith[/TD]
[TD]Edited[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD] 10/5/18 2:16 PM[/TD]
[TD]John Smith[/TD]
[TD]Open*[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]
[TD] 10/5/18 4:16 PM[/TD]
[TD]John Smith[/TD]
[TD]Edited*[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD] 10/6/18 2:16 PM[/TD]
[TD]John Smith[/TD]
[TD]Open*[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD] 10/6/18 2:16 PM[/TD]
[TD]John Smith[/TD]
[TD]Moved[/TD]
[/TR]
</tbody>[/TABLE]

What I'm trying to do:
I want to count the amount of touches. Touches = Edited and Open
However, I do not want to capture Edited and Open together if they happen within a span of 20 minutes of each other.

Example of Results Looking for:
Number of Touches: 5 (2 hour time difference counted on Seq 3)

Anyone have any ideas?

 

[Special-K99]

How do you get 5 ?

Sequence 1 Opened 10/1/18 2:41 Edited 10/1/18 2:41,
2:41 is within 20 mins of 2:41 so netither of them get counted.
So I make it 2 (for Sequence 3 Opened (1) and Edited (2).

How do you get 5 ?

 

[FanofExcel18]

How do you get 5 ?

Sequence 1 Opened 10/1/18 2:41 Edited 10/1/18 2:41,
2:41 is within 20 mins of 2:41 so netither of them get counted.
So I make it 2 (for Sequence 3 Opened (1) and Edited (2).

How do you get 5 ?

I meant to write in the original post anything with a * was counted( the 5).
So for sequence 1, I would only count that as 1 hit vs 2. For Sequence 3, its a 2 since they are 2 hours apart. Make Sense?

 

[Special-K99]

Your data suggests the following.

There are only ever TWO records for a sequence, one labelled OPENED the other labelled EDITED or MOVED.

Is that so?

 

[FanofExcel18]

Your data suggests the following.

There are only ever TWO records for a sequence, one labelled OPENED the other labelled EDITED or MOVED.

Is that so?

There could be more than one edited for sequence but during different date/times. Example would be Sequence 1 has 6 entries, each with an edited but each with a different date/timestamp.