Do you mean within the macro code or within the final formula I'm trying to have the code produce? The final formula works when I enter it into a cell. It's the code to produce that formula that is giving me trouble (mainly how to show the comma within a R1C1 COUNTIF after a variable column number and how to show an ampersand in the final formula when ampersands are used in creating the code).

Thanks