Time Sheets 2.xlsm

Please help. If Worksheets Monday through Weekend C3:C8 type is "D" then add Monday through Weekend D3:D8 on my Week Summary Sheet.

This is the formula I currently have but it is giving me error message #NAME?

=SUMPRODUCT(--(Monday:Weekend!C3:C8="D"),--(Monday:Weekend!D3:D8))


Please help.... I've been at it for days with no solution.

Thank you,