Easy way of summarising total orders for a product code from a table

[Timja]

Hi,

Probably a very poor description in the title and i know this is easy to do but having complete memory blank of how to do it or even describe it!

I have a spreadsheet which shows me things like customer name, date of booking, description, product code of what product range they are buying, Quantity of people.
Basically i need to summarise how many people in total are buying what product range.

E.g.


Prod ¦ People
A ¦ 120
B ¦ 200
C ¦ 230
B ¦ 50
B ¦ 100
A ¦ 160

So i need an easy way to get the following result:

A ¦ 280
B ¦ 350
C ¦ 230

There are about 30 products and 1500 lines of data.

Any pointers greatly appreciated, can filter and do a SUM but know there is a simple way to do this.

Many thanks!

[Ranelagh]

Inserting a pivot is the easiest way to do this.

Alternatively using formula - select column A and copy to a new column (D1). On the data tab, remove duplicates so you only have 1 of each value. Sort. Then in cell E1 use =SUMIF(A:A,D1,B:B)

[MarvinP]

Hi Timja,

This looks like an easy Pivot Table answer to me.

See http://chandoo.org/wp/2009/08/19/exc...bles-tutorial/

ALSO - you need to update your profile and add the version of Excel you are using. The answer will differ depending on which version of Excel you are using. Where you are from also helps us understand any language differences or our own incentive to help.

[Timja]

Thanks guys! - I knew it would be simple but having a completememory loss!

Only recently started using Excel 2010 and struggle to find anything since it all moved about!

Pivot Table done and all sorted.

Have updated profile accordingly.

Thanks again.