Sum values based upon multiple sets of criteria

Here is my situation:

I have a spreadsheet that contains almost 5,000 rows and need a formula or someway fo make it easier to format. I am currently working in excel 2007 but do have access to 2010.

Column A: Dates
Column B: Dollar Amount
Column C: Name
Column F: Number

I want to total the values in column F based on if the Column A values are the same AND if the values in Column B are the same AND if the values in Column C are the same.

It would also be great if I could automatically get excel to insert a blank row in between each total so that the spreadsheet is easier to view.

Any help would be greatly appreciated. I don't know where to start.

Thanks,

If it is sorted, look at Data>Subtotals.

Not quite sure if I replicated your data correctly, but take a look at this...

If I'm off base, maybe attach a workbook with some sample data of what you have, and what you'd like to see. (Click "Go Advanced" at the bottom right to upload a workbook)