Subtotal - Clarification

  • Thread starter Thread starter DumbCluck
  • Start date Start date
D

DumbCluck

Name Type Amount
A P 10.00
A P 20.00 total 30.00
A R 15.00 total 15.00 grand-total 45.00
B P 10.00
B R 50.00
B P 5.00
B P 25.00
How can I sort this data by name/type and total amount on name/type and
grant-total on name?
regards,
 
First, select a single cell in the range, use data/sort, select Name from the
first dropdown and Type from the 2nd.
Then use Data/Subtotals and specify at each change in Name, use Sum to add
Amount. Then do Data/Subtotals AGAIN, and specify at each change in Type, use
Sum to add Amount AND BE SURE TO DESELECT Replace Current Subtotals
 
Back
Top