Report - SubTotal

[ian]

I imported data into worksheet with Part#, Client# and
Sales. I want to do the total of Sales by grouping Part#
and in each Part# group I want to do the subtotal of Sales
by grouping Client#. Is there a way to do it without a lot
of programming? Thanks.
Ian

 

[Debra Dalgleish]

You can create a pivot table to summarize the data. There are some
instructions and links here:

http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm

For your example, you could add Part# and Client# to the
Rows area, and Sales to the Data area.