Your first formula: adding a column with SUM
This is the lesson I've been looking forward to. Everything before now was setup. This is where the sheet starts doing real work for you.
Right now, if you've got a column of numbers, groceries, gas, whatever you've been typing in, you're probably adding them up in your head or on your phone calculator and typing the total in somewhere. That's what we're fixing today.
Why this matters more than it looks like it does
If you're typing the same total in by hand, you've already planted a mistake for later. You just haven't run into it yet. Add one more expense next month and forget to update that hand-typed total, and now your sheet is quietly telling you something untrue. It'll look fine. It just won't be right.
A formula fixes that for good. You add a number to the column, the total updates itself. No remembering, no redoing math, no sheet telling stories.
The actual steps
Let's say you've got expenses in column B, rows 2 through 10. Row 1 is your header, "Amount" or whatever you called it.
- Click into the cell right below your last number. So if your data ends at B10, click B11.
- Type an equals sign. This tells the sheet you're about to give it a formula, not just a number.
- Type
SUM( - Now select the range you want added up. You can click B2 and drag down to B10, or just type it:
B2:B10 - Close the parenthesis:
) - Press Enter.
So the whole thing looks like =SUM(B2:B10). Press enter and there's your total, and it'll update itself every time you change a number in that range.
If you added everything right, this should feel a little dull. That's the sheet working. A correct total isn't supposed to be exciting. If you were expecting fireworks, I'm sorry, this is spreadsheets, the fireworks are quieter than that.
The mistake you will make, and it's fine
Nearly everyone types the range wrong the first time. You'll write B2:B9 and miss your last row, or you'll grab an extra blank row and your total looks a touch off. Don't fret. Click the cell with your formula, look at what's highlighted in the sheet, drag the little blue handle on the corner to adjust the range, and it fixes itself.
I left a wrong formula on my own sheet for two weeks once, pointed at the wrong column entirely, and nobody caught it, me included. When I finally found it my stomach dropped for a second, thinking I'd broken something important. Then I saw the numbers had been wrong in a way that didn't actually matter for what I was using it for, and I laughed out loud, alone at my desk. So it happens. The sheet doesn't judge you for it, and neither do I.
A word on how many columns to even sum
Truly, you do not need forty categories here. I've watched people build budgets with a column for every little thing, coffee, parking, snacks, and then walk away from the whole sheet in three weeks because it's exhausting to keep up. Five or six columns is plenty. "Food" can just be food. A rough number you'll actually keep updating beats a precise one you'll give up on by February.
A quick aside about paper
Not everything needs a formula, or even a sheet. I keep birthdays and anniversaries in a little paper notebook, one page per month, no formulas anywhere near it. My March page still has an old coffee ring on it from before I had children, and I've never rewritten that page clean. That's just what March looks like now, coffee ring and all. I won't pretend spreadsheets are the answer to everything, because they aren't. Use the tool you'll actually keep using. Sometimes that's SUM. Sometimes that's a notebook with a stain on it.
Before next time
Add a SUM formula under one real column of your own numbers, even if it's just five rows. Watch it update when you change a number. That little moment where it recalculates on its own, that's the heart of this whole course.
- C