Countifs with Multiple Criterion

I need help writing a formula that will count the entries in w2:w2500 from sheet 2 if 3 criterions are met.

1st does column b2:b2500 on sheet 2 =Ordered
2nd is the date in column f2:f2500 on sheet 2 =>c5 (date from sheet 1)
3rd is the date in column f2:f2500 =<d5 (date on sheet 1)

If criteria are met count w2:w2500 (note: there will be some empty cells in Column W)

Just so you know I tried this but the count was not accurate
=COUNTIFS('Sheet 2'!$W$2:$W$2504,"<>",'Sheet 2'!$F$2:$F$2504,"=<$c5",'Sheet 2'!$F$2:$F$2504,"=>$d5",'Sheet 2'!$B$2:$B$2504,"=Ordered")

Amend what you have to be

=COUNTIFS('Sheet 2'!$W$2:$W$2504,"<>",'Sheet 2'!$F$2:$F$2504,"<="&$c5,'Sheet 2'!$F$2:$F$2504,">="&$d5,'Sheet 2'!$B$2:$B$2504,"Ordered")

Still gives me a 0.

I just tested it on a quick mock up and it correctly counted based on the criteria.
Any chance the cells in column B containing "Ordered" might have leading/trailing spaces?

I copied your formula and "ordered" is selected from a drop down box so there shouldn't be any spaces. I will try it again or something else. Thanks.

I would next examine the dates. Are they numeric values?

Cutter; your 1st post worked. I guess I didn't copy the complete formula or something. THANKS for your help and time!

You're welcome. I'm glad you got it working.