Filtering SUMIFS values largest to smallest

Hello all,

I'm just doing a simple SUMIFS summary table for finances by account per month for a year. I am trying to sort a specific month largest to smallest, but the formula does not appear to reference the correct criteria after filtering.

Any ideas here? I was under the impression that the filter range would fluctuate with the values and it would not cause issues.

Thanks,
Scott

You can create Pivot Table then sort
one thing - month what you want to sort should be on the first position in Rows field
see example (May sorted Largest to smallest)

Hey Sandy,

I appreciate the reply - however I'm hesitant on using a Pivot here just because I already have a bunch of tables on the actual workbook I'm using. Do you know of a way to sort the actual SUMIFS table without have reference issues?

Thanks,
Scott

The columns in the table are dependent on each other, so they can not be sorted independently. As you can see, when you sort one column, the whole table is sorted.
The best way as I know is just PT.

Hmm bummer that seems like a limitation to me. I was hoping that there could be an independent sort on individual months and have the remaining months just update freely based on the new account ID lookup. Oh well I'll keep playing with it

Thanks!
Scott

you can use Large function in the next column to sort in descending order