Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summarizing data
Hello all,
who can help me: i have a data sheet with customer orders and production months. how can i make report in which i can count: a: orders per customer per production month b: list tem all in one preview report without typing all ranges by hand. i now do all by selecting every range each time (of which i am getting tired off). little eaxmple: naam total orders jan feb customer a 94 2 6 cutomer b 29 6 0 customer c 47 6 2 formula used for above preview: =AANTAL.ALS(Orders!C5:C40;$H$83) The range is much bigger (than c5:c40) and production month varies (jan feb mrt and so on) customer a jan customer a feb customer b jan customer b jan customer c jan customer c feb customer c feb How do i let the report count all orders whithout doing too much tpying. thanks for your help and awaiting your answer/solutions. I hope you can help Ronald Bakker |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summarizing data
Hi,
The simple answer is use a pivot table. The second question is not clear to me. -- Cheers, Shane Devenshire "skwirrel" wrote: Hello all, who can help me: i have a data sheet with customer orders and production months. how can i make report in which i can count: a: orders per customer per production month b: list tem all in one preview report without typing all ranges by hand. i now do all by selecting every range each time (of which i am getting tired off). little eaxmple: naam total orders jan feb customer a 94 2 6 cutomer b 29 6 0 customer c 47 6 2 formula used for above preview: =AANTAL.ALS(Orders!C5:C40;$H$83) The range is much bigger (than c5:c40) and production month varies (jan feb mrt and so on) customer a jan customer a feb customer b jan customer b jan customer c jan customer c feb customer c feb How do i let the report count all orders whithout doing too much tpying. thanks for your help and awaiting your answer/solutions. I hope you can help Ronald Bakker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing data | Excel Discussion (Misc queries) | |||
Summarizing Column Data | Excel Worksheet Functions | |||
Summarizing data | Excel Discussion (Misc queries) | |||
Summarizing data | Excel Discussion (Misc queries) |