Sort a table with a formula column

What is the best way to sort a table with a formula column?

I have a table with columns:

- Market name
- Criteria 1 (value)
- Criteria 2 (value)
- Criteria 3 (value)
...
- Score (formula calculating a weighted average based on criteria 1, 2, 3...)

I need to sort a table by score (from higher to lower).

I would appreciate any help on this

Good afternoon,

I think if you make references to the individual cells (instead of [Column 1]) it should sort properly.

Best of luck,

So simply sorting through Data|Sort and selecting that column for sorting in descending order doesn't work?

Thanks for the advise. I found out what was wrong, and it works now.