summing data from a list

[bfont]

Ive got a list of about 100 transactions, with the type in one column and the
amount in the next column. There's only about 10-12 types of transactions,
and I want to create a table that lists the type of transaction and sum of
the amounts of that type of transaction from the list. Is there a quick way I
can do this? Thanks.

 

[Gary''s Student]

Use a Pivot table:

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

 

[trip_to_tokyo]

Hello bfont.

I have just put up a proposed solution for you at:-

www.pierrefondes.com

You really only need to look at the:-

PivotTableDataAndPivotTable

- Worksheet, which is where you will find the solution I propose for you.

The other 2 Worksheets might help you to understand what I have done.

Please click Yes if my posting has been helpful to you.

Thanks!