Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter data
I have the following table:
Columns: A B C D Date From Date To A2 B2 Date Unit Category Time 12/9/07 Wilts U/S 2:00 12/9/07 Wilts S 8:00 13/9/07 YAA S 9:00 15/9/07 YAA U/S 3:00 and so on....... How can I filter the data so that when i enter two dates in cell A2 and B2, it gives me the totals time under each unit and category between those dates -- Geo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter data
In C2 enter:
=SUMPRODUCT(--(A8:A11=$A$2),--(A8:A11<=$B$2),D8:D11)*24 where your Table (including the header is A7:D11) Jim May "Geo" wrote: I have the following table: Columns: A B C D Date From Date To A2 B2 Date Unit Category Time 12/9/07 Wilts U/S 2:00 12/9/07 Wilts S 8:00 13/9/07 YAA S 9:00 15/9/07 YAA U/S 3:00 and so on....... How can I filter the data so that when i enter two dates in cell A2 and B2, it gives me the totals time under each unit and category between those dates -- Geo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
Excel 2007 Data Filter - When using cut it clears all data | Excel Discussion (Misc queries) | |||
in data/filter/auto filter | Excel Worksheet Functions | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
How to filter and list data based on different data. | Excel Worksheet Functions |