I have a portion of a file that has the date, sale and card type. Here is what it looks like:

A B C D
1/3/05 $10 VISA
1/3/05 $20 MCARD
1/3/05 $30 MCARD
1/3/05 $10 AMEX 1/3/05
1/4/05 $50 VISA 1/4/05
1/5/05 $30 VISA
1/5/05 $20 AMEX 1/5/05

I created column D which will display a single date at the end of the day when there are multiple sales. What I need to do is get daily totals for the VISA and MCARD together, and keep the total for AMEX separate. The number of transactions on any day can range from 1 to 20. Ideally I would like the data to the right.

Any help would be appreciated.
Thanks,
Phillycheese