(VBA) COUNTIFS using MID not working

Hello

I have the following code to count all entries that match the following criteria:

1 Check if "w" is in the text (eg. "tw1", "tw3" etc) and
2 Check if corresponding row in column N has "Pass"

Then put the result in cell R2 in Sheets("Analysis")

The code I have is:

Please Login or Register  to view this content.

I am getting "Object does not support this property or method error.

Could someone help me to find what I am doing wrong

I am now thinking that I can't mix Countifs and Mid syntax as above. I have changed the code to search wild card "*w*" in the range. Code is now:

Please Login or Register  to view this content.

Whilst this has stopped the error, I am not getting the correct result!

Help!