Sumif between 2 dates and specify criteria

[jpenny]

Sheet1
08/01/2006 08/31/2006
Totals
WB61 ?
WB62 ?
WB72 ?
WB83 ?

Sheet2
A B C
1) 08/07/2006 WB61 15
2) 08/08/2006 WB83 73


Ok, this is what I am trying to do. I need help to figure out what the
formula would be where i've posted "?". It needs to sum up values in
column C where it's between the 2 dates and equals the WBxx codes. This
is hard to explain so I hope it makes sense.

 

[Bob Umlas]

Assuming the 8/1 is in B1, the 8/31 is in C1, and the first "?" is in B3,
the WB61 is in A3:
=SUMPRODUCT(--(Sheet2!$A$1:$A$100>=$B$1),--(Sheet2!$A$1:$A$100<=$C$1),--(A3=
Sheet2!$B$1:$B$100),Sheet2!$C$1:$C$100)
and fill down

 

[caper1175]

Worked like a charm.....thanks for taking the time to help me out.
Cheers!