I have a spreadsheet where I would like to sort the results of a certain

column starting at the highest number down to the smallest number, when I do

this using the Z to A button, the last column (which works out a percentage

with a formula I have put in using the cells I wish to sort) gets messed up

and just shows #DIV/0! I think this maybe because it is automatically sorting

the total of the sorted column at the top of the spreadsheet after a sort

instead of the bottom which is in turn messing up where the formula is

looking to work out the percent.

Hope this makes sense and someone can help

Ruth

## Bookmarks