Next, you’ll apply formulas to calculate totals for each month. For example, use the SUM function to calculate your total income and expenses for each month, and then use AUTO SUM to quickly calculate the total across all categories.

In cell D2 (Savings), enter the formula =SUM(B2:C2) to add up income and expenses. Copy this formula down the column using the AutoFill feature.

Key Strokes

• =SUM(range) (Apply the SUM function)
• Ctrl + D (Use AutoFill to copy formulas down)