Income and expense spreadsheets can be useful tools to help you see where your personal or business finances stand. After you've assembled all your financial data and created a worksheet to contain your income in one column and your expenses in another, you can use Excel's "SUM" function to create a formula to instantly add and total each column.
-
1.
Open your income and expenses Excel worksheet.
-
2.
Select an empty cell beneath the last item in your "income" column.
-
3.
Type "Total Income" in this cell, then press the "Enter" key.
-
4.
Select the cell directly beneath the "Total Income" label.
-
5.
Type "=SUM(" into this empty cell.
-
6.
Select the first entry in your "Income" column, press the "Shift" key, select the last income item in that column, then press the "Enter" key to calculate your income total.
-
7.
Select an empty cell beneath the last item in your "Expenses" column.
-
8.
Type "Total Expenses" in this cell, then press the "Enter" key.
-
9.
Select the cell directly beneath the "Total Expenses" label.
-
10.
Type "=SUM(" into the empty cell.
-
11.
Select the first entry in your "Expenses" column, press and hold the "Shift" key, select the last expense item in the same column, then press the "Enter" key to calculate your total expenses.
