Only filter up to a certain row

[31RHCP]

I have a spreadsheet containing data of cities basically it looks like this:

Headings
Cities
....
Cities
Basic Mathematical operations using data from the cities section (there are no formulas anywhere else in the sheet).

I have Auto filters so that data can be sorted numerically or alphabetically by criteria such as population, name, county, state. The problem arises from the operations performed on this data below the list of cities. For example one such operation sums the population of all cities. So, whenever I try to sort by population, this cell becomes the highest value when filtered.

My questions is: is it possible to exclude everything below the last city listed from the filtering process?

Thanks.

 

[JoeMo]

Separate everything below the last city from the last city row by a blank row.

 

[borgem]

If you are using 2007 or 2010, you can highlight the region you with to filter and use: Insert > Table. Once you have the table, go to the Design ribbon and select the checkbox for Total Row in the Table Style Options. It will give you an unfiltered row at the bottom which has drop-down menus for built in functions, like sum. You can even write your own functions in there.