How do I subtotal data and then sort these subtotals in ascending.

J

JulieD

Hi Steve

personally i would sort the data by the category on which to subtotal
then subtotal it (data / subtotals)
then collapse it down so i could only see the subtotal lines
select them
choose edit / goto / special - visible cells only
copy
go to a new sheet & paste
then sort that list.

hope this helps
Cheers
JulieD
 
D

Dave Peterson

Just hide the details and sort the visible cells.

when you show the details, you'll be amazed (I was!) that excel did it
correctly.

Steve_Wood wrote:
 
Top