Countifs Multiple Criteria

[Robot1]

I have searched and searched and all answers do not seem to work. I am trying to count how many instances of a name and a job happen during a date range. I can count for my entire sheet but when I try to add the date range, i return a 0 each time.

My original formula is
=COUNTIFS(Hotlist!$N$2:$N$3000,B$6,Hotlist!$M$2:$M$3000,$A7)
Where N column range is Name ref in B6
Where M column range is Job ref in A7

I want to only find Name and Job in date range 2/1/2024 - 2/29/2024
I can do this by separating my data to individual month tabs but would prefer not.

 

[hagia_sofia]

Something like (I do not know where you you have your dates):

=COUNTIFS(Hotlist!$N$2:$N$3000,B$6,Hotlist!$M$2:$M$3000,$A7,Hotlist!$O$2:$O$3000,">="&C8,Hotlist!$O$2:$O$3000,"<="&C9)

where Hotlist!$O$2:$O$3000 represents the column with dates, and C8 and C9 stand for 2/1/2024 and 2/29/2024.

 

[Robot1]

Thanks @hagia_sofia - I had that formula but had the date reference in the front. Then I didn't think it was working as I was getting no data. Well, I was looking at the wrong column. Time to start he weekend.

 

[Robot1]

Have a new problem with the same formula. It is not counting the same data for the same day. I have three criteria that are all the same but it is only counting it an 1 instance.

4/4/2024 - Jim - CHR

4/4/2024 - Jim - CHR

4/4/2024 - Jim - CHR