SUMPRODUCT Help with Multiple Worksheets and Criteria

[sonialara]

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,

[jeffreybrown]

Hello & Welcome to the Forum,

First create a named range (in this example SheetList) listing the sheets to be included in the formula.

Then

Please Login or Register  to view this content.