Countif 2 conditions are met including a date range

[Corleone]

Hi
Im trying to get a spreadsheet to return the cumber of "Completed" activities which have been identified as
Completed in column Q and where the date in column P on those activities occur between the dates shown in cells J2 & L2

I Tried with the formula below but its returning 0 When it should return 7

=COUNTIFS(Q21:Q1000,"=Complete",P21:P1000,"=AND(p211000>MIN(j2),p211000<MAX(L2))")

thanks in advance

 

[barry houdini]

Try this version

=COUNTIFS(Q21:Q1000,"Complete",P21:P1000,">="&J2,P21:P1000,"<="&L2)

I'm assuming that J2< L2

 

[Corleone]

Barry - Just what i was after - Many Thanks