Keep average formula the same when sorting?

[jasomeye]

Hi, I have a database of student information including first name, lat name, region, country, grades and SAT scores. The sheet also includes formulas for average grade by region, however I need to sort the sheet by different columns depending on what I'm doing and the average formulas are only accurate when it is sorted by region (because that is how it was sorted when I wrote the average formula). I'm sure this is fairly simple, any ideas?

 

[ChrisM]

Probably best to put this into a pivot table. You will need to configure the pivot table to show you the average (or you might need to make a pivot formula to do it), but once it's done, you can spin your data any way you want and those region numbers won't change.

You just need to make Region one of the left-most columns or rows of your table, then all the fields you want to manipulate should be to the right of Region.