Needing to Add Cells Based on the Date in Another Cell

[Pickle29]

I'm not even sure if this is possible, but this is an example of the data I'm working with:

Date Value 1 Value 2
11/9/2011 18:31 Option 1 2
11/9/2011 17:08 Option 1 3
11/9/2011 16:14 Option 1 4
11/9/2011 15:13 Option 1 0.4
11/8/2011 21:45 Option 1 0.2
11/8/2011 4:58 Option 1 1.5
11/7/2011 5:18 Option 1 1.6
11/6/2011 5:12 Option 1 4
11/5/2011 3:58 Option 1 8
11/4/2011 9:10 Option 1 7
11/4/2011 3:47 Option 2 1.6
11/3/2011 4:14 Option 1 3
11/2/2011 3:46 Option 1 2.8
11/1/2011 9:51 Option 1 4
11/1/2011 4:07 Option 1 6.4


What I need to be able to do is add the cells in column 3 based on the dates in column 1. If there are multiple rows in column 1 with the same date, I need Excel to add together the corresponding cells in column 3. Is this even possible?

[Special-K]

Take a look at Pivot tables