Sort Totals & Linking Sheets in a Workbook

Good afternoon eddonaldson

Originally Posted by eddonaldson

My problem is that when I sort for say all $ received for a particular type of training or from a specific client, etc it continues to show the overall income for the sheet instead of the amount for the sort. This is also true for Sheet Two, the expense sheet. How do I correct this?

Do you mean autofilter? If so, use SUBTOTAL instead - this can be set to only calculate visible rows, thus :
=SUBTOTAL(109,A1:A10)

Originally Posted by eddonaldson

Problem # 2: Is there a way to link Sheet One and Sheet Two so that I can see her net income after Income minus Expenses or must I continue to use a calculator to accomplish this?

Good grief man, absolutely not!! This isn't the dark ages you know

We'll add Sheet1, A1 to Sheet2 B2
Click on Sheet1 A3 and press =, then click on Sheet1 A1 and then press +. then goto Sheet2 B2 and click on the cell and press Enter. Hey presto! Every time you change one of these cells, the formula will recalculate.

HTH

DominicB