I think I figured out what will work:

drow = 4
dcol = 8
Sheets("1-4 Wks").Cells(drow, dcol).Formula =
"=sum(d4:g4)"

I have looked for something like this for a long time.
Finally, I stumbled onto it.