Excel Formulas: Let the Sheet Do the Sums

A formula is a sum the sheet does for you — and keeps doing, every time a number changes. Excel is full of them, but you only need a handful for real life: one that adds, one that averages, one that finds the biggest, and one small clever one that makes a decision. This lesson walks through each, slowly, with real numbers.

What a formula is

Every formula starts with an equals sign: =. That sign is the whole secret. Type =5+3 in a cell and press Enter, and the cell shows 8. Leave the = off and Excel treats what you typed as a word, and no sum happens. Real formulas point at cells instead of carrying their own numbers: =B2+B3 means “whatever is in B2, plus whatever is in B3” — and if those numbers change, the answer changes with them. The formula itself lives quietly inside the cell: click the cell and you will see the formula written out in the formula bar, the long line above the column letters, while the cell itself shows the answer.

SUM: add a column, worked slowly

Say column B holds four weekly grocery spends: B2 is 24, B3 is 18, B4 is 31, B5 is 12. To add them:

  1. Click cell B6 — the empty cell under the last number. The total will live here.
  2. Type =SUM( — SUM is Excel’s adding word.
  3. Click B2, then hold Shift and click B5. Excel writes B2:B5 — every cell from B2 down to B5.
  4. Type ) and press Enter.
  5. B6 shows 85 — 24 + 18 + 31 + 12, added exactly, and ready to re-add itself the moment you correct any of the four.

The shortcut: Microsoft built a button for this one. Click the cell under your numbers, then on the Home tab click AutoSum (it wears the Greek letter Σ). Excel guesses the run of numbers, shows you the formula, and one press of Enter accepts it. Check its guess covers all your numbers before you press Enter.

Check a new total by hand, once

The first time a sheet adds for you, add the first few numbers yourself — on paper or a phone calculator — and compare. If they match, the formula is looking at the right cells and you can trust it from then on. If they do not match, the usual cause is the range: it stopped one cell early (B2:B4 instead of B2:B5), or it included the total cell itself. Click the answer cell, read its formula in the formula bar, and fix the range there.

Three more, one line each

IF: the sheet makes a small decision

IF is the clever one, and it is only a question with two answers. Here is a whole one, walked through slowly:

=IF(B2>100,"over budget","fine")

So if B2 holds your electric bill and it is 86, the cell reads fine. Change the bill to 120 and the same cell flips to over budget — nobody touched the formula; the answer follows the number. Two honest details: word answers must wear their quote marks, or Excel goes looking for a cell named over budget and complains; and numbers in a question never wear quotes.

Copy a formula down a column: the fill handle

  1. Suppose each row is a month, column B is the electric bill and column C the water, and D2 already holds =B2+C2 — January’s combined bill.
  2. Click cell D2. Look at its bottom-right corner: there is a tiny square. That is the fill handle.
  3. Press on the little square and drag it down over the rows below, then let go.
  4. Every row now has its own copy — D3 reads =B3+C3, D4 reads =B4+C4. Excel moves the row numbers along as it copies, which is exactly what you want, and why nobody types the same sum twelve times.

Three troubles people actually meet

The same formulas in other programs

Here is the good news: SUM, AVERAGE, MAX, MIN, and IF are written exactly the same way in Google Sheets and in LibreOffice Calc (which is free) — learn them once here and you know them everywhere. The Google Sheets lesson uses the very same sums. Where Excel itself differs is only in where it lives: on a computer it is a program you open, and on a phone the free Excel app does the same sums with the same formulas typed the same way — the buttons are simply squeezed into a strip you may need to open to find Home and Formulas. If you are choosing between the programs themselves, Office suites compares them in plain words.

Words in this lesson

📖 New to spreadsheets entirely? Start with Google Sheets: The Grid That Adds Up for You — it explains the grid itself with a full worked budget, and every sum in it works in Excel too.

Straight 2 Work Tech, LLC — patient, plain-words tech help.
(813) 770-6082