Counting events on a given day

I have searched the forum for this and was not able to find anything conclusive.
I have a spreadsheet which in one column has a series of dates/time and in another numbers that represent the outcome of certain events that occurred at that date/time. The number of events in a certain day is random. i would like to be able to sum the numbers that have occurred on specific dates with each date having its own sum. What would be the best way to acomplish that?

attached is an example

Originally Posted by Ron Coderre

As was mentioned.....A Pivot Table handles your request easily.

Using your posted workbook as an example:
(Note: I added headings to your data: DateTime and Amount)

Select Sheet2
From the Excel Main Menu: <Data><Pivot Table>
Use: Excel……Click [Next]
Select your data on Sheet1……Click [Next]
Click the [Layout] button

ROW: Drag the DateTime field here
COLUMN: (Leave this area blank)
DATA: Drag the Amount field here
If it doesn't list as Sum of Amount...dbl-click it and set it to Sum
Click [OK]
Select where you want the Pivot Table…Click [Finish].

I know....not quite what you want.....YET...

Right-Click on the DateTime heading in the Pivot Table
Select: Group and Show Detail.....Group
...Check: Days
...Check: Months
Click [OK]

Now, the Pivot Table data is grouped by Month and Day
with Totals by Day.

Is that something you can work with?

To refresh the Pivot Table, just right click it and select Refresh Data

this is a bit different than the way i wanted it done, but it is actually better. Thank you very much for your detailed explanation.