Hi, everyone. I'm trying to use the following in a VBA macro, but it just doesn't want to work for me. I'm getting "Expected: End of Statement." I understand it's because of the quotation marks, but it's the only way I thought I could pull in ">0." Basically, I'm trying

Here was the original line of code:

TempString = "IF(RC[4]>0,""1,"","""")

Here is the code I'm trying to use. Basically, I want it to use two conditions, rather than one now:

TempString = "IF(COUNTIFS(R[-1]C[4],"*MAP*", RC[4], ">0"),""1,"","""")"