Attention all you Excel geniuses out there!

I’m a college student with parents fed up with my crazy spending habits, so they offered me an ultimatum if they are to continue their financial support: I have to provide them with a list of how much I’m spending every month, item by item, date by date.


I have two separate excel spreadsheets.

Spreadsheet 1
The first one has dates down the vertical axis (the 1st to the 31st of every month) and on the horizontal axis I have my credit cards listed.
http://s841.photobucket.com/albums/z...ent=excel1.gif

Spreadsheet 2
The second spreadsheet has each transaction in detail (ie the date, how much and which credit card was used)
http://s841.photobucket.com/albums/z...ent=excel2.gif

What I want to do is have, for example, cell C9 from “spreadsheet 1” look in column A of “spreadsheet 2” for all the dates corresponding to “December 5th, 2009” and segregate the ones that are “Visa” then add the “amounts” together that are visa and display that amount in the cell.

Basically what I’m trying to do is track how much I’m spending on each card, day by day. The problem arises if I use the same card more than once on a given day.


Please let me know if you can help me! Your help is greatly appreciated!
Thanks
Robby