Calculating discount uptake

[Guest]

I would like to figure out how many people have taken up a discount of 33% or
50%, at what rate (earlybird or regular) and what they bought.

The columns I have are item (1 item, 2 item, 3 item), rate (EB or REG) and
discount (0%, 33%, 50%).

An example is as follows:
ITEM RATE DISCOUNT
1 item EB 0%
2 item EB 33%
1 item REG 50%
3 item REG 50%
2 item EB 0%
2 item EB 33%

I would like a formula to figure out how many people bought:
1 item at EB rate with 0% discount
" " " " " " 33% discount
" " " " " " 50% discount
1 item at REG rate with 0% discount
" " " " " " 33% discount
" " " " " " 50% discount
2 item at EB rate with 0% discount
" " " " " " 33% discount
etc, etc.

Can anyone help??

 

[Guest]

You can do that with a pivot table. select the data and then Data|PivotTable
-> Follow the wizard.

Place the item in the left column and the Rate next to it an finally the
discount next to that so that all 3 are in the left column. Now add the Item
to the data protion of the table and you should get a count...