Formula Previously Used

[Rogojosh]

Hello again, I received fantastic help with a formula previously to check a date range. I'm trying to apply this but changing the date/month range and the value it should look for. So this worked:
=COUNTIFS('Insp Data'!O4:O2974,">=" & 45139,'Insp Data'!O4:O2974,"<="& 45169,'Insp Data'!P4:P2974,"A persons name")
New range:
=COUNTIFS('Insp Data'!N2:N3000,">=" & 45078,'Insp Data'!N2:N3000,"<="& 45107,’Insp Data’!J2:J3000,”Compliant”) which returns the #NAME? error. Help much appreciated thanks.

 

[Fluff]

You have the wrong type of quotes around Compliant. They should be vertical rather than sloping.

 

[Rogojosh]

Many thanks, I can see that now, although I would say I thought I only had one type of quotes on my keyboard? Which is....." Will try again.

 

[Fluff]

Glad to help & thanks for the feedback.

 

[Rogojosh]

Glad to help & thanks for the feedback.

Working, yay, this website is the best thing every. I have no idea where I got the slanty quotes from tbh, ghost keyboard moment? Gosh, I should try and go outside sometime, excel takes over your life!