Google Sheets Formulas for Small Business: Plain-English Starter Guide
Freelancers, solo operators, and very small business owners using Google Sheets as a practical business operating system.
On this page
You don't need to learn every Google Sheets function. You need the handful that answer real business questions: how much did I invoice, what's overdue, which jobs are still active, and what price goes with which service. Five formulas cover almost all of it.
Start with these five: SUM/SUMIF to total amounts, COUNTIF to count rows by status, IF to flag overdue invoices, FILTER to show only the rows that need action, and VLOOKUP/XLOOKUP to pull a price or rate from a list. Each one below is copyable, with the plain-English version underneath. This is spreadsheet structure, not accounting or tax advice.
This is for you if…
- You run an invoice tracker, expense log, or simple CRM in Sheets
- You can edit cells but formulas still feel fragile
- You want the few formulas that pay off, not a function encyclopedia
- You'd rather copy a working formula than build one from scratch
Skip it if…
- You need pivot tables, scripts, or query-language reporting
- You want a full Sheets course rather than a starting set
- Your numbers feed taxes or audited books — confirm those with a professional
If you're still setting up the overall system, start with how to set up Google Sheets for a small business and come back here for the formulas.
The five formulas, mapped to what you're actually asking#
Each row is a business question, not a function name. Find the question you have, then jump to its formula below.
| Business question | Formula | What it does |
|---|---|---|
| How much did I invoice? | SUM / SUMIF | Add amounts, optionally by client or status |
| How many jobs are still active? | COUNTIF | Count rows where status is Active |
| Is this invoice overdue? | IF | Flag Overdue when it's past due and unpaid |
| Which rows need action right now? | FILTER | Show only rows matching a condition |
| What's this client's rate? | VLOOKUP / XLOOKUP | Pull a value from a price or rate list |
Total what you invoiced, with or without a filter#
The everyday question is "how much money is on this sheet?" SUM adds a whole column. SUMIF adds only the rows that match a condition — one client, or everything not yet paid.
=SUM(C2:C)Add every amount in column C, starting at row 2. Leaving the range open-ended (C2:C) means it keeps counting as you add new rows.
=SUMIF(F2:F,"<>Paid",C2:C)Add the amounts in column C, but only for rows whose Status in column F is not Paid. That's the total still owed to you. <> means "not equal to."
Count how many jobs sit at each status#
COUNTIF answers "how many?" — how many active projects, how many overdue invoices, how many leads marked Won. It counts rows where one column matches a value.
=COUNTIF(D2:D,"Active")Count every row in column D where the status reads exactly Active. Spelling and spacing must match, so a stray Active with a trailing space won't be counted.
Use a dropdown, not free text
Counting and totaling only stay reliable if the status values are consistent. Put a fixed dropdown (Data → Data validation) on your status column so nobody types active, Active, and Aktive into the same sheet.
Flag overdue invoices without checking dates by hand#
You shouldn't update "Overdue" manually. IF compares the due date to today and labels the row for you — but only when the invoice isn't already paid.
=IF(F2="Paid","Paid",IF(AND(E2<>"",E2<TODAY()),"Overdue","On track"))Read it plainly: if the Status in F2 is Paid, show Paid. Otherwise, if there's a due date in E2 and it's before today, show Overdue. If not, show On track. TODAY() refreshes each day you open the sheet, so the flag stays current on its own.
The same overdue logic sits at the heart of a working invoice tracker — set it up once and the column maintains itself.
Show only the rows that need action#
FILTER answers "what should I look at right now?" without deleting or hiding anything. It pulls matching rows into a fresh range, leaving your source data untouched.
=FILTER(A2:F, F2:F="Overdue")Return every column from A2:F where the Status in column F equals Overdue. Put this on a review tab to get a live "needs chasing" list that updates itself as statuses change.
A filtered view is not a deletion
FILTER and the Filter menu only show a subset of rows. The hidden rows still exist. Confusing "filtered out" with "deleted" is one of the most common beginner mistakes — see the beginner terms guide if a tab, range, or filtered view ever trips you up.
Pull a client's rate from a price list#
When the same prices or rates live in one place, XLOOKUP fetches the right one by name. Say you keep rates on a tab called Rates, with client names in column A and rates in column B:
=XLOOKUP("Brightwork", Rates!A2:A4, Rates!B2:B4, "Not found")Look for Brightwork in the names range Rates!A2:A4 and return the matching cell from the rates range Rates!B2:B4. The last part, "Not found", shows instead of an error when there's no match.
VLOOKUP does the same job and is still everywhere, but it breaks more easily — it can't look leftward, and inserting a column can silently return the wrong value. If you're choosing between them, the VLOOKUP vs XLOOKUP comparison lays out exactly when each one is the safer pick.
Make formulas survive other people editing the sheet#
A formula that only you understand is a hidden dependency, not an asset. Two habits keep yours safe to hand off:
- Use a helper column with a plain label instead of burying logic inside one giant formula. A column headed "Overdue?" is self-explaining; a nested formula three tabs away is not.
- Test with three fake rows before you trust it. Add a paid invoice, an overdue one, and an on-track one, then check that the status, totals, and any review tab all react correctly.
If that test fails, stop building. Duplicate the file, mark the broken spot, and fix one layer at a time: source data first, formulas second, review views last.
What to do next#
Pick the one question that's costing you the most right now — usually "what's overdue?" or "how much is unpaid?" — and add just that formula to your real sheet today. Don't rebuild everything at once.
If a sheet is starting to juggle too many people, permissions, automations, or regulated workflows, read the upgrade decision guide before forcing more onto one spreadsheet. And if you're working from a template, make a clean copy first so you never edit the original by accident.
Questions people ask
Which Google Sheets formula should a small business learn first?
What's the difference between SUM and SUMIF?
Why does my COUNTIF or SUMIF return the wrong count?
Are these formulas a substitute for accounting software?
We aim to keep this accurate and date-stamp it when product steps change. We don't claim hands-on product testing we haven't done, and we'll always point to the free, native route first. How we work.