CountIfs how to

[FanofExcel18]

My Data

1	A	B	C	D
2	Sequence	Date/Time	Who	What
3	1	10/1/18 2:41 PM	John Smith	Open*
4	1	10/1/18 2:41 PM	John Smith	Edited
5	2	10/4/18 2:15 PM	John Smith	Open*
6	2	10/4/18 2:15 PM	John Smith	Edited
7	3	10/5/18 2:16 PM	John Smith	Open*
8	3	10/5/18 4:16 PM	John Smith	Edited*
9	4	10/6/18 2:16 PM	John Smith	Open*
10	4	10/6/18 2:16 PM	John Smith	Moved

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

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.