Dim eRowP As Long
eRowP = Sheets("Production Log").Cells(Rows.Count, 1).End(xlUp).Row

Range("H11").Formula = "=SUMPRODUCT(--('Production Log'!$H$5:$H$" & eRowP &
"=$C11),--('Production Log'!$K$5:$K$" & eRowP & _
"=H$8),--('Production Log'!$J$5:$J$" & eRowP & "=H$9,1))"

is giving a 1004 Runtime Error

your help is highly appriciated
--
Thanks,
Baapi