Multiple identical dates, different values, how to output sum?

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!

Hi safetymuffin

The title might be bad, but when compared with the user name ......

Welcome to the forum.

I agree that the pivot table is probably the best way, but just to show another way of skinning this particular cat I have used subtotals. Clicking the 2 (top left) will hide the details. "Find and replace" can be used to get rid of the word "Total"

Regards
Alastair