Adding the contents of rows with the same date

Hopefully someone can help me with this:

I have a table of data with the rows sorted by date. There are multiple entries with the same date, and I need to add the contents of each row with the same date, preferably into another table so I don't lose any of the original data.

I can't find any VBA function that would do this. Can anyone help me out with the code?

Thanks
Greg

Thanks Sweep, I tried the SUMIF function, but I can't figure out how to set the criteria as equal to

so far I have =SUMIF(A6:$A$9,"=",C6:$K$9), where column A is the date, and column C thru K contains the data.

I want to add columns C:K for every row that has the same date, and the formula that I wrote doesn't seem to work

*bump*

Can anyone help make the above formula work?

or any other suggestions for macros?

Thanks

Update-

SUMIF doesn't work because it puts the results in one cell. What I need is to total each column in every set of rows with the same date, and I think I need to use VBA, but I can't seem to find a function that does this.