SUM of hours for a given Workstation

[jeffcvip]

I have gotten stuck at the operation every time I try to construct this spreadsheet.
So, I need help.

I have two tables. On is a reference for times and the other is a growing table of dates.
Both tables have the same columns (Parts).
The first table has Workstations in rows and Parts in columns. The cells contain times needed for each Workstation to build a certain Part.

The second table has Projects in rows and Parts in columns. The cells contain dates needed for each Project that requires certain Parts.

I would like to SUM the hours associated for a Workstation for all Projects between two dates.
What I have so far does not work:
=SUMPRODUCT(--(Sheet1!E35:U49>=Sheet2!F4),--(Sheet1!E35:U49<=Sheet2!F5),--(Sheet1!D4:D28=Sheet2!B8),Sheet1!$E$4:$U$28)

Thanks for any help you can give using Excel 2003.
Jeff C.

 

[mgrady11]

Try using a Sumif or Sumifs formula. It will allow you to use specific criteria(s) to sum based on.

If it is only summing based on a single criteria.
The Excel SUMIF Function


If there are multiple criteria to sum on.
The Excel SUMIFS Function

 

[jeffcvip]

If have multiple criteria. Since I'm using 2003, SUMIFS is not available.