Sorting a subtotal

[samilam]

I have a spreadsheet with a column with dollar amounts. I have subtotals on a change of a certain column, but I want to sort the list by smallest subtotal amount to largest subtotal amount. I've gotten it to work before, but now when i try, it warns me and wants to unsubtotal my group to sort. How do I keep my subtotal, but sort on the formula'd subtotal field?

 

[bluedragon2]

On the subtotal buttons, select number 2 then highlite and sort on the column you want.

 

[samilam]

That is what I tried to do, but when i do, it tries to unsort my groups.

 

[bluedragon2]

When you click on the number two tab, are you just seeing the subtotals on the sheet? Not sure what your data is, but when I created a sample of three columns of data, I did a sort on column B then ran a subtotal, then clciked on tab 2, then did a sort on the subtotals and it worked great.

Blue

 

[slezakm2000]

Hi Samilam,

I think I might have figured out what could be happening. I had the same thing happening on one of my spreadsheets. I had a sum at the bottom of my subtotaled column. As soon as removed the row with the sum in it, it sorted fine. Either that or you could look for any record or row that doesn't have a value in you "on change" column. Hope that helps.

Michelle