Summing columns based on date?

[sonicvi]

I need some help with a macro. I have data in the following format

date|value1|value2|value3

The dates are month and year and there are multiple entries for each. What I need to do is to add all the value1's, value2's, and value3's for each date. I need it to show in four new columns with the date and each sum.

So for example
111964 2767 913 718
111964 2122 700 10
111964 9224 3044 0
121964 14927 4926 3270
121964 9681 3195 10
121964 16335 5391 65


There are three entries of each value for 11/1964. I need a sum of each column. I need to do this for the entire spreadsheet of about 50K entries.

Any help would be GREATLY appreciated!

[StephenR]

It sounds like a pivot table would do the job. Why do you think you need a macro?

[sonicvi]

Because I'm not an excel expert and don't know what a pivot table is

[StephenR]

Fair enough.

Pivot tables are not very complicated. Here's one guide (plenty of others via Google): http://www.cpearson.com/excel/pivots.htm

Post a sample workbook if you get stuck.

[sonicvi]

thanks very much. That was not difficult at all.