How to Create a Formula for Income & Expenses in Excel
- Open your income and expenses Excel worksheet.
- Select an empty cell beneath the last item in your “income” column.
- Type “Total Income” in this cell, then press the “Enter” key.
- Select the cell directly beneath the “Total Income” label.