You can't. A pivot tabel will accomplish the same thing as subtotaling and
will allow you to sort by subtotals...

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
HTH...

Jim Thomlinson


"creating a reference list" wrote:

I have 4000 lines of data and I have used the sub total function to obtain
the value that I need. How can I sort the data by the sub total value?