This is my function. Of course COUNTIFS isn't case sensitive. I need a way to look at a cell and determine if it is within a certain month and if it is it will then evaluate another cell in that row and determine if it contains a specific case sensitive text.

=COUNTIFS(C2:C795,">"&DATE(YEAR(TODAY()),10,1), A1:A11,"<"&DATE(YEAR(TODAY()),10,31), B1:B11, "*"&"EA"&"*")

Example is this:

Capture.PNG

When I try and search for "EA" I also get back the "ea" in Ready.

Hope this makes sense. Thanks in advance for any insight.