Using countifs with If or function

[anshikam]

IF(OR((C2:C2323>=00:00, C2:C2323<=00:59, COUNTIFS(F2:F2323, "=M")))

The above formula doesnt work

What I am doing?
Counting the no of "M" in a coloumn for patient entry between 00:00 to 00:59 hours from another coloumn.
data set looks like this:

Name Patient in Time Gender
Anshika 00:15 F
Mike 01:15 M
Jack 00:30 M
John 00:45 M

Should give me 2 as a result from the above dataset

Have tried pivots but somehow not able to group by range

 

[Michael M]

How about

=COUNTIFS(C2:C2323,">="& "0:00",C2:C2323,"<=" & "00:59",F2:F2323,"M")

 

[anshikam]

How about

=COUNTIFS(C2:C2323,">="& "0:00",C2:C2323,"<=" & "00:59",F2:F2323,"M")

Hello,

I was actually able to get pivot to work. Thanks for your response !! Will look at what you shared.

 

[Michael M]

Ok, glad you got it working...