I'm trying to create a COUNTIF formula with the R1C1 format that should look like the following after being run:

=COUNTIF(I24:I24,"<"&DP24)



I'm having trouble getting the row number variable, "less than" sign, and ampersand to work correctly when all in the same formula. What I have now (below) gives me a Run-time error 1004 (application-defined or object-defined error). Variations of what's below place a hardcoded TRUE/FALSE in the cell. Here is what I have now:

Cells(x, LastColumnNumber + 10).FormulaR1C1 = "=CountIF(R" & x & "C" & 9 & ":R" & x & "C" & LastColumnNumber & ","">"" & " & " & Cells(x, LastColumnNumber + 8).Address)"""

Any suggestions on how to make this work?

Thanks!