Countif based on 3 conditions

[ArunBalaji]

Hi all,

Attached is the spreadsheet that shows start time, end time, total time, Region & status.

I am looking for a formula that counts the start time within time range 9 to 10 and status =completed.

Can someone guide me ?

Regards,
Arun

 

[jamescooper]

Use COUNTIFS

 

[ArunBalaji]

James. Thank You. I am using the below formula.

=COUNTIFS(A2:A101,">=9:00",A2:A101,"<=10:00")

But i want to add one more condition, need to check status too.

Ex: time between 9 to 10 and status = completed

Please advise

 

[jamescooper]

Just add another criteria and criteria range after. This would be criteria 3 and criteria range 3.

Does that help?

 

[ArunBalaji]

I have attached the screenprint. Hope this might explain my need.