help with sales report

[rodchar]

hey all,

i have some data like so:

ga, aug, rep1, $10.00
ga, atl, rep2, $5.00
ga, aug, rep1, $7.50
ga, aug, rep3, $5.00

is there a way in excel to convert to report format like so:

ga
-> aug
--> rep1 -> $17.50
--> rep3 -> $5.00
---> total -> $22.50
-> atl
--> rep2 -> $5.00
---> total -> $5.00

thanks,
rodchar

 

[Jacob Skaria]

Use Pivot tables

Add Column headers
Select the entire range including headers
Open Pivot Table wizard

Add column 1 2 3 t the row lables
Add amount column to the values

Also refer some interesting tutorals at
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

If this post helps click Yes

 

[Shane Devenshire]

Hi,

You can use the Data, Subtotal command to do this, although I prefer the
Pivot Table.

Sort your data by column B. Then choose Data, Subtotal and choose column
B's title from the At each change in, Use function Sum and check the column
with your values.

 

[rodchar]

thanks for the help everyone,
rod.