Concatenation on CountIf Formula

Please consider:
Be polite. Thank those who have helped you.
Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.