Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|