Well the if statement already looks like this!
=IF(AND(COUNTIF($C$8:$C$600,C8)=2,C8>=$I$5,D8<=$I$6),"in",IF(AND(COUNTIF($C$8:$C$600,C8)=3,C8>=$J$5,D8<=$J$6),"in",""))
So I'm trying to get it to avoid data that doesn't have numbers is it classes it as true