Sumif between 2 dates and specify criteria
 

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.

Sumif between 2 dates and specify criteria
 

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


wrote in message
oups.com...
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.

Sumif between 2 dates and specify criteria
 

Worked like a charm.....thanks for taking the time to help me out.
Cheers!
Bob Umlas wrote:
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


wrote in message
oups.com...
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.