Google Sheets formulas that just work

Pick the task, copy the formula, paste it in. Every page gives you the exact formula for one real job — COUNTIF, XLOOKUP, subtraction, percentages — with a Copy button and a short plain-English explanation of how it works and how to adapt it.

Concatenate in Google Sheets Join text from several cells in Google Sheets with CONCATENATE, the & operator, and TEXTJOIN with a separator. Copy-paste formulas.
COUNTIF in Google Sheets Count how many cells match a condition in Google Sheets with COUNTIF. Copy the formula, plus variations for text, numbers, greater-than and wildcards.
COUNTIFS in Google Sheets Count rows that meet several conditions at once using COUNTIFS in Google Sheets. Copy the formula plus date-range and OR patterns.
IFERROR in Google Sheets Wrap any formula in IFERROR to replace error values with a blank or your own text in Google Sheets. Copy-paste examples.
IFS Function in Google Sheets Replace nested IFs with the IFS function in Google Sheets. Copy the formula and see how to add a catch-all default.
INDEX MATCH in Google Sheets Combine INDEX and MATCH in Google Sheets for lookups that work in any direction. Copy the formula and a two-way (row + column) version.
Percentage Formula in Google Sheets Calculate percentages in Google Sheets: percent of a total, percentage change, and add or subtract a percent. Copy the formulas.
Subtraction Formula in Google Sheets How to subtract in Google Sheets: subtract one cell from another, subtract a whole column, or subtract a percentage. Copy-paste formulas.
SUM Formula in Google Sheets Add up numbers in Google Sheets with SUM, SUMIF and SUMIFS. Copy formulas for a column, a range, and conditional totals.
XLOOKUP in Google Sheets Use XLOOKUP in Google Sheets to find a value and return a match from another column — with a copy-paste formula and a not-found fallback.