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??

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...
--
HTH...

Jim Thomlinson


"NeedHelp" wrote:

> 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??