LinkBack URL
About LinkBacks
tichtoe 
Assuming your data is in A2:E6, this combines both conditions:Hopefully this demonstrates everything you need to construct your formula.
=COUNTIFS(B2:B6,"PASS",E2:E6,101,C2:C6,">="&TIME(0,2,0),C2:C6,"<"&TIME(0,2,30))
Assuming your data is in A2:E6, this combines both conditions:Hopefully this demonstrates everything you need to construct your formula.=COUNTIFS(B2:B6,"PASS",E2:E6,101,C2:C6,">="&TIME(0,2,0),C2:C6,"<"&TIME(0,2,30))
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks