Browse by problem
Formulas are organized by what you're trying to do, not by function name — because nobody searches for "SUMPRODUCT," they search for "total by region."
Lookup & MatchingPull values from other tables, match records, and compare lists.7 formulasText CleanupSplit names, trim spaces, fix capitalization, and extract text.11 formulasDates & DeadlinesOverdue flags, days remaining, due dates, and date math.5 formulasCounting & SummarizingCount and sum with conditions, percentages, and running totals.18 formulasConditional LogicIF, IFS, AND, OR — build status flags and pass/fail rules.5 formulasError Fixes#N/A, #VALUE!, #REF!, #DIV/0! — what they mean and how to fix them.10 formulasFinance & BusinessBudgets, variance, margins, commissions, and invoices.4 formulasSmall BusinessInventory, sales pipelines, customer lists, and expenses.6 formulasGoogle SheetsSheets-specific functions: QUERY, ARRAYFORMULA, REGEX, and more.6 formulasExcelExcel-specific features: LET, LAMBDA, Power Query, and dynamic arrays.5 formulas