sorting a column with calculations

I have a spreadsheet I want to sort a number of different ways. 2 of the columns have sums totaled at the bottom. When I sort is there a way to have the sums equal the sorted amount each time I sort?

thanks

Hi

Maybe I'm missing something critical, but why not sort the rows that don't have the totals??? Or is this the point of the post - to work out where the totals are and only sort the non total rows?

rylo

each row has 12 cells. I need to only sort by 2 of them, cost codes and P.O's. I need to match the total (1000 rows) to the breakdown by p.o.# and cost code totals.

That is the end goal. I am using auto filter but I want the sorted total each time I need a different sort. I have to do over a hundred different sorts on each sheet and need the individual subtotals. Is there a way?

Thanks

Hi

Example file time with steps for some different scenarios and the expected result for those scenarios.....


rylo