Row total
=SUM(B2:D2) adds three columns on a budget row and copies down the table.
What are Google Sheets formulas?
A formula is an instruction in a cell that calculates a result from other cells, ranges, or built-in functions. Every formula begins with =. When inputs change, the sheet recalculates so dashboards and models stay live without manual copy-paste. Formulas are the default automation layer inside the grid before Apps Script or add-ons.
When to use it
Use formulas for math, lookups, text cleanup, conditional labels, and live reports that should update whenever someone edits source data.
When to skip it
Skip formulas when a pivot table, filter view, or one-time CSV export is enough. Very complex branching sometimes belongs in Apps Script for readability and permissions.
How it works
-
1
Click a cell, type =, then pick a function or reference other cells like =B2*C2.
-
2
Copy formulas down columns or use dynamic arrays so one formula fills many rows.
-
3
Name important ranges so formulas read =SUM(Revenue) instead of cryptic letters.
-
4
Watch for error tokens like
-
5
Layer QUERY, FILTER, and ARRAYFORMULA when flat SUM rows are not enough for reporting.
-
6
Use the formula generator or function help panel when you know the outcome but not the syntax.
Examples in Google Sheets
Lookup price
=VLOOKUP(SKU, Prices!A:B, 2, FALSE) pulls unit price for an order line from a price list tab.
Status label
=IF(E2>=100%, "On track", "Behind") turns percent complete into plain language for executives.
Build this without starting from a blank cell
Use a Better Sheets tool for Google Sheets formulas, then watch a walkthrough when you want the full pattern.
Better Sheets resources
Common mistakes
- Hard-coding numbers inside formulas instead of input cells on a Settings tab.
- Entire-column references A:A on huge sheets, slowing every edit.
- Mixing text and numbers in one column, breaking SUM and chart axes.
- Duplicating the same formula thousands of times instead of one spill formula.
- Sharing models without explaining which cells are inputs versus formula blocks.
Frequently asked questions
- Formula vs function?
- The formula is the whole = expression. Functions are named operations inside it like SUM or IF.
- See all formulas at once?
- View > Show formulas toggles the grid to display formula text in every cell.
- Formula vs Apps Script?
- Formulas recalc in cells for anyone with edit access. Scripts run code for menus, triggers, and external APIs.
- Formula vs pivot table?
- Pivots summarize visually without cell formulas. Formulas stay live inside model layouts you design.
- Why
- Misspelled function, wrong locale separator, or a name that Sheets does not recognize.
- Convert formula to values?
- Copy the range and Paste special > Values only when you need a snapshot that should not recalc.
- Learn formulas fast?
- Start with SUM, IF, and VLOOKUP, then use the glossary and Better Sheets tutorials for each new function.
Related Tutorials
Watch how Google Sheets formulas works
Learn Google Sheet Formulas The Hard Way
Google Sheet Basics - The Absolute Basics
Your First Formula
Ultimate Checklist in Google Sheets
Related blog posts
Guides that explain Google Sheets formulas in more depth.
Beginners Guide to Using Index, Row, and Column | Simply useful Google Sheets Formulas
You may be using Google Sheet to do math and find that you need to iterate a number. ROW() gets you the row you're on, and helps you with this.
Read post →Getting Started in Google Sheets Spreadsheet Management
Users can also customize the appearance of their spreadsheets with different fonts, colors, and themes.
Read post →Spreadsheets Explained! 5 Levels of Difficulty: From Basic Text Input to Google Apps Script
Five increasingly difficult ways of explaining spreadsheets in Google Sheets: The basics of Google Sheets text Menu items in Google Sheets Math inside Google Sheets Using Formulas in Google Sheets Apps Script in Google Sheets
Read post →Related glossary terms
Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text sits in quotes, and operators like + and & combine values. Sheets recalculates when inputs change, so syntax errors show as #NAME? or #ERROR! in the cell.
Read guide →visual formulas in Sheets
Visual formulas are spreadsheet layouts where the formula output is meant to be seen, not just calculated: sparkline strips, emoji status icons, color scales, and REPT bars that communicate trend and health at a glance. They sit between raw numbers and full chart objects for dense dashboards.
Read guide →QUERY
QUERY runs a SQL-like statement against a range of cells and returns a new table of results. You pass a data range, a query string with SELECT, WHERE, ORDER BY, and optional headers. It is the fastest way to filter, sort, group, and pivot sheet data without helper columns.
Read guide →ARRAYFORMULA
ARRAYFORMULA tells Google Sheets to treat a formula as an array operation so one expression fills many cells at once. It is common with IF, VLOOKUP, and math on full columns before dynamic arrays made many patterns automatic. It still matters for legacy sheets and explicit control.
Read guide →Done reading about Google Sheets formulas?
Membership unlocks 636+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.