Worst title ever?

Here's the outline. I get multiple reports with dates and values, let's say, number of widgets. I then have to take those values, by date, and give a rolling 365 total of widgets created, by day.

The guy who used to sit at my desk created a sheet that works.. ok, but it could obviously be a 4 minute thing instead of a half hour thing.

EXAMPLE
SET 1
COMPANY----DATE----#WIDGETS
ABC-----------6/1/2013-------1
ABC-----------6/1/2013-------1
BBC-----------6/1/2013-------1
CDF-----------6/1/2013-------1
ASD-----------6/1/2013-------1
CDF-----------6/2/2013-------2
CBA-----------6/2/2013-------2
CBA-----------6/2/2013-------2
ABC-----------6/2/2013-------2


This will go on until 6/30/2013 in the same manner. Company is irrelevant to the data at the end, as we just monitor # of widgets produced on a rolling 365 day chart. As shown, production is not regular, and I cannot format cells to output in the only simple way I know how.



SET 2

DATE-----#WIDGETS
6/1/2013-----5
6/2/2013-----8


Currently I'm supposed to manually add or use the SUM function in excel to manually add the multiple entries to end up with SET 2's result.

Is there a simple way to set up SET 1 so that it outputs the sums of the multiple identical dates with sums in to a single date/sum?

I apologize if this is an easy thing to search for and find, maybe I don't have the proper language to ask the question.. I've seen some stuff when searching about SUMIF, but I can't really figure out how to apply it here.


Thanks for any assistance given!