Combine/Add Data for Multiple Dates in Excel

[H7H12]

Hi there,

Hoping you can help me with the following issue!

I have an Excel spreadsheet that contains data for several dates, so:

Date (A) Number (B)
01/01/2011 15
01/01/2011 27
02/01/2011 14
02/01/2011 1

As you can see in column A, there are two entries for both '01/01/2011' and '02/01/2011'. I wish to add the number entries for these dates together, so I would have a more streamlined spreadsheet, like so:

Date (A) Number (B)
01/01/2011 42
02/01/2011 15



I can of course go through the spreadsheet manually and add everything together, but I was wondering if there was something I could do in Excel, to ensure I don't make any errors?

I am using Excel 2007, with Windows XP.

Apologies - I cannot space the columns out, but I hope it's clear.

 

[SteveO59L]

Try a pivot table

 

[VoG]

Maybe like this

Excel Workbook
	A	B	C	D
1	01/01/2011	15	01/01/2011	42
2	01/01/2011	27	02/01/2011	15
3	02/01/2011	14
4	02/01/2011	1
Sheet2

 

[Benjaminmin]

if you want to add the two numbers and keeping the text , you could use something like this (assuming they are in A1 and A2):

=LEFT(A1,11)&" "&RIGHT(A1,2)+RIGHT(A2,2)

 

[H7H12]

Thank you all for yr help! I went with the Pivot Table option, but thanks for so many great suggestions.