Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summary based on channel & date ranges
Hi,
In sheet1 I have Row 7 as header. From row 8 there is data. In header have items in columnB, quantity in columnF, channel in columnH & date in column I. I want a routine which will give me a summary in sheet2 based on channel selected and start/end date. -------------------------------------------- Channel:<Select Start Date:<Select End Date:<Select Items Quantity A 10 B 30 C 60 D 90 E 80 F 70 -------------------------------------------- The quantity is sum of quantity date wise/channel wise. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting based on date ranges | Excel Discussion (Misc queries) | |||
Formatting based on date ranges | Excel Discussion (Misc queries) | |||
Conditional Format based on date ranges | Excel Worksheet Functions | |||
Moving data based on date ranges | Excel Worksheet Functions | |||
Summary of Multiple Date Ranges | Excel Programming |