summarizing data

[skwirrel]

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

 

[ShaneDevenshire]

Hi,

The simple answer is use a pivot table. The second question is not clear to
me.