You have to double up those quote marks inside your string:

Range("J11").Formula = "=SUMIF(D:D,""=""&L12,E:E)"
Range("J12").Formula = "=COUNTIF(D:D,""=""&L12)"
Range("J14").Formula = "=SUMIF(E:E,""39999"",E:E)"

or for the last one:
Range("J14").Formula = "=SUMIF(E:E,""""&39999,E:E)"




Matthew Dyer wrote:

I'm having some issues when trying to use a macro to generate formulas
in a worksheet.

Range("J10").Formula = "=count(e:e)"

This line works perfectly. Cell J10 will have the formula =count(E:E)
placed in it when the macro is ran. I tried to just follow the basic
setup using other formulas and I'm getting very frustrated...

Range("J11").Formula = "=SUMIF(D:D, " = "&L12,E:E )"
Range("J12").Formula = "=COUNTIF(D:D, " = "&L12)"

Both of the above lines return a boolean value instead of the actual
results of the sumif/countif formulas

Range("J14").Formula = "=SUMIF(E:E, "39999",E:E )"

This above line gives me compie error - expected: end of statement???

Is there a simple way to have a macro place a formula into a specific
cell in a sheet?

--

Dave Peterson