tweaking a formula

[Jaimee001]

Hi Team,
Here is the formula: IF(AND(C2<21,COUNTIFS(A$2:A$20651,A2,C$2:C$20651,">20")=0),"<21","")

what I'd like is to get the data where C2 is between 11 and 21. I'm not sure how to write that.
I have the formula where C2 is <11 and I thought I tweaked it by the above but it's not giving me what I want.

Looking forward to you expertise!!!

Regards,
Jaimee

 

[David Evans]

I think your problem is in your AND() syntax .... if I'm correctly divining the issue ...

AND(C2>11,C2<21) - you may need to tweak that for <= scenarios ...

If I've misunderstood, post an example file for clarity ...