help with sales report

  • Thread starter Thread starter rodchar
  • Start date Start date
R

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
 
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.
 
Back
Top