Sorting in Excel

Hi!

When i have a column where each cell is programmed to sum up the numbers in the row to the left, am I then able to have it automaticly sort from highest to lowest. Or do I constantly have to sort the column again manualy as new numbers are summed up?