SUMIF in VBA using variable

[CodyMonster]

Hoping to get some help here.
Trying to get this sumif formula to get added to my sheet. However, it's throwing out a 1004 error.
Just need another set of eyes, if anyone has a second?

Sub test()

Dim LastParagonRow As Long

LastParagonRow = Sheets("Paragon_CEBO_Data").Cells(Rows.Count, "A").End(xlUp).Row

Sheets("Output").Range("H2").Value = "=SUMIFS(Paragon_CEBO_Data!P$2:P""&LastParagonRow&"",Paragon_CEBO_Data!$H$2:$H""&LastParagonRow&"",$F2,Paragon_CEBO_Data!$B$2:$B""&LastParagonRow&"",$G2)"


End Sub

 

[Cubist]

The "" are not needed around variables.

Sub test()
    Dim LastParagonRow As Long

    LastParagonRow = Sheets("Paragon_CEBO_Data").Cells(Rows.Count, "A").End(xlUp).Row

    Sheets("Output").Range("H2").Formula = "=SUMIFS(Paragon_CEBO_Data!$P$2:$P" & LastParagonRow & ", Paragon_CEBO_Data!$H$2:$H" & LastParagonRow & ", $F2, Paragon_CEBO_Data!$B$2:$B" & LastParagonRow & ", $G2)"
End Sub

 

[Artik]

I think you went a little overboard with the quotes.

Sheets("Output").Range("H2").Formula = "=SUMIFS(Paragon_CEBO_Data!P$2:P" & LastParagonRow & ",Paragon_CEBO_Data!$H$2:$H" & LastParagonRow & ",$F2,Paragon_CEBO_Data!$B$2:$B " & LastParagonRow & ",$G2)"

Artik

Edit: Too late

 

[CodyMonster]

It's always something dumb...
Thanks!!!!