sum product if three fields are true

Heres a Multi criteria sum product Statement, I have an error log and a production sheet.
What I want is if the error log reports an error, I want it to return the error to the production log for the correct date to the production sheet matching the Line and Zones, So basically it would be count if, the Lines are = and the Zones are = and the Dates are =.

Each Row in Sheet 2 is one error, so if Columns "Date" & "Line" & "Zone" in sheet Errors = Columns "Date" & "Line" & "Zone" in sheet Production, then it should count each item and add them in Column H in the Production Sheet. I hope this makes sense, all I want is the total amount of errors for each zone and line to automatically calculate, based on what is inputted into the Error Sheet.

I am trying to use this code, but it seems like it is only working in the first Zone on each Line (probably because the Line cells are merged), any ideas how to fix this without renaming the Line or hiding a row with the names in each cell???

{=SUM((Errors!$A:$A=Production!$B6)*(Errors!$B:$B=Production!C$2)*(Errors!$I:$I=Production!C$3))}

For illustrative purposes I have included an attachment, with both sheets and a sample of what it should look like, also in the production sheet I highlighted where values should be for a better visual...