How do I summarize values?

I have a spreadsheet with 3 columns of data. The first column has order codes, many of which are duplicated. The 2nd column is the test name and the 3rd colum is how many times that order code has been ordered. So it looks somewhat like this:


Ordercode Testname Timesordered
222 Test2 13
111 Test1 4
333 Test3 45
222 Test2 24
111 Test1 52


How can I use Excel to add up all the times each ordercode was ordered (i.e. 11, 22 and 333 in the above example) and put them in a new column? This would then show ordercode 111 was ordered a total of 56 times, ordercode 222 was ordered 37 times and ordercode 333 was ordered 45 times.

Try creating a Pivot Table


Here are some links on how to use pivot tables

http://www.microsoft.com/dynamics/us...s_collins.mspx

http://peltiertech.com/Excel/Pivots/pivotstart.htm