Version (Excel 2003)

I am trying to make a spreadsheet for book-keeping.

When I have sorted my data, ie (Lets say income) so income catagories
occupies the top rows and expense occupies the bottom rows. Obviously at the
bottom of the spreadsheet their is a row which calculates the totals.

Now I will hide the row containing the expense rows, so as only to be able
to see the income rows and total row. I would like to be able to format my
spreadsheet so it automatically prints the view (no matter how many times I
change it). Also
the total row calculates using the hidden rows as well as the visable rows.

Thanks