Your first formula: adding a column with SUM
Okay sooo. This is the lesson I've been waiting to get to, not gonna lie. Everything before this was setup. This is where the sheet starts actually doing work for you.
Here's the thing. 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 the thing 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 made a future mistake. You just haven't met it yet. Add one more expense next month and forget to update that hand-typed total, and now your sheet is quietly lying to you. It'll look fine. It just won't be true.
A formula fixes that permanently. You add a number to the column, the total updates itself. No remembering, no redoing math, no lying sheet.
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 "hey, I'm about to give you 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:
) - Hit Enter.
So the whole thing looks like =SUM(B2:B10). Hit enter and boom, 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 just feel boring. That's the sheet working. A correct total is not supposed to be exciting. If you were expecting fireworks, sorry, this is spreadsheets, the fireworks are quieter than that.
The mistake you will make, and it's fine
Almost 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 slightly off. Don't panic. 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, including me. When I finally found it I went cold for a second thinking I'd broken something important. Then I realized the numbers had been wrong in a way that didn't actually matter for what I was using it for, and I just laughed out loud alone at my desk. So. It happens. The sheet doesn't judge you for it, and honestly neither do I.
A word on how many columns to even sum
Real talk, you do not need forty categories here. I've watched people build budgets with a column for every tiny thing, coffee, parking, snacks, and then abandon the whole sheet in three weeks because it's exhausting to maintain. 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 quit 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, formulas nowhere near it. My March page still has an old coffee ring on it from before I had kids, and I've never rewritten that page clean. That's just what March looks like now, coffee ring and all. I'm not going to pretend spreadsheets are the answer to everything, because they're not. 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 whole point of this course, honestly.
- C