I can manually type a date into this formula and get my desired result but if I reference a data validation list the formula does not work.

[bjiii2231]

I am looking to to sort data between two dates. I can manually type the dates into the formula but if I reference a drop down cell the formula does not work.

This formula works:
=COUNTIFS('PLANNER 25'!$A$2:$A$176, ">=3/1/2024",'PLANNER 25'!$A$2:$A$176, "<=7/24/2024",'PLANNER 25'!$C$2:$C$176,'Repair %'!A23)

This formula does not work:
=COUNTIFS('PLANNER 25'!$A$2:$A$176, ">=C21",'PLANNER 25'!$A$2:$A$176, "<=E21",'PLANNER 25'!$C$2:$C$176,'Repair %'!A23)

I have tried various version with and without "" or >= symbols... if it references another cell the formula does not work.

Thanks for any help

 

[Joe4]

Welcome to the Board!

Try this:

=COUNTIFS('PLANNER 25'!$A$2:$A$176, ">=" & C21,'PLANNER 25'!$A$2:$A$176, "<=" & E21,'PLANNER 25'!$C$2:$C$176,'Repair %'!A23)

 

[bjiii2231]

Welcome to the Board!

Try this:

=COUNTIFS('PLANNER 25'!$A$2:$A$176, ">=" & C21,'PLANNER 25'!$A$2:$A$176, "<=" & E21,'PLANNER 25'!$C$2:$C$176,'Repair %'!A23)

This did it thank you for your support!!!

 

[Joe4]

You are welcome!

The important thing to remember is that only literal text goes between double-quotes (as that is the text qualifier).
All variables, ranges, etc must be OUTSIDE of the double-quotes.
And then then just sew them all together with &.