Hi,
This is my demo data:
28/02/2019 12:07:51 1726443 53 136763 User1 Operation1
28/02/2019 12:07:52 1726448 51 136764 User2 Operation2
28/02/2019 12:08:30 1726444 53 136765 User1 Operation1
What I'm trying to do is to
lookup for User1 and Operation 1 between 28/02/2019 00:00:00 and 28/02/2019 18:00:00 and count how many times operation1 exist for the user 1.
I have a similar formula =COUNTIFS('RAW Data'!$I:$I,Stats!G238,'RAW Data'!$AB:$AB,">="&Stats!$Z$3,'RAW Data'!$AB:$AB,"<="&Stats!$AA$3,'RAW Data'!$A:$A,Stats!$I$237)
which works fine but in this case I have time on my date column.
Is anyone here who can help with that?
I'm looking to see between a date and time range how many times an operation was completed by a user.
Thank you for help.
Bookmarks