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