Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totals by type between dates
Columns are as follows:
Order Date Type Quantity 01/05/2006 Red 100 01/06/2006 Blue 100 01/07/2006 Green 100 01/08/2006 Red 100 01/09/2006 Red 100 01/10/2006 Blue 100 I want to add up how many Red were sold between 1/5 and 1/10. Any ideas? Thanks -- JerryS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totals by type between dates
Say dates in Column A, Type in B, and Qty in C, from A2 to C100.
In D1 enter Type to find, In D2 enter start date, In D3 enter end date. Try this formula: =SUMPRODUCT((B2:B100=D1)*(A1:A100=D2)*(A1:A100<=D 3)*C1:C100) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "JerryS" wrote in message ... Columns are as follows: Order Date Type Quantity 01/05/2006 Red 100 01/06/2006 Blue 100 01/07/2006 Green 100 01/08/2006 Red 100 01/09/2006 Red 100 01/10/2006 Blue 100 I want to add up how many Red were sold between 1/5 and 1/10. Any ideas? Thanks -- JerryS |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totals by type between dates
I didn't equalize the ranges.
Use this instead: =SUMPRODUCT((B2:B100=D1)*(A2:A100=D2)*(A2:A100<=D 3)*C2:C100) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ragdyer" wrote in message ... Say dates in Column A, Type in B, and Qty in C, from A2 to C100. In D1 enter Type to find, In D2 enter start date, In D3 enter end date. Try this formula: =SUMPRODUCT((B2:B100=D1)*(A1:A100=D2)*(A1:A100<=D 3)*C1:C100) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "JerryS" wrote in message ... Columns are as follows: Order Date Type Quantity 01/05/2006 Red 100 01/06/2006 Blue 100 01/07/2006 Green 100 01/08/2006 Red 100 01/09/2006 Red 100 01/10/2006 Blue 100 I want to add up how many Red were sold between 1/5 and 1/10. Any ideas? Thanks -- JerryS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you type squares or "to the power" in excel?? | Excel Discussion (Misc queries) | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Countif using dates | Excel Worksheet Functions | |||
Help with automatic dates | New Users to Excel |