Count cells in a Date Range that contain case sensitive text in another cell on same row

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.

Check if the text EA is followed by space. If so, you could try adding space in the COUNTIFS criterion.

Formula:

Please Login or Register  to view this content.