Countifs not giving desired result -Why

[ARUNCHENNAI]

Countifs not giving desired result -Why
Table
Part No Time
330370K010 8:00
330370K010 9:00
330370K010 8:30
330370K010 9:30
330370K010 9:45
330370K011 8:00
330370K011 9:00
330370K011 8:30
330370K011 9:30
330370K011 9:45

Start_Time End_Time Part_No Count Status Formula
8:00 9:00 330370K010 #VALUE! Error =COUNTIFS(D6:D15,"="&D18,D6:E15,">="&B18,D6:E15,"<="&C18)
6 Correct =COUNTIFS(D6:E15,">="&B18,D6:E15,"<="&C18)
5 Correct =COUNTIFS(D6:D15,"="&D18)

 

[Hui]

The formulas should only be single column
=COUNTIFS(D6:D15,"="&D18,E6:E15,">="&B18,E6:E15,"<="&C18)
I think

 

[ARUNCHENNAI]

Thank you Hui. Its working.