How this Google Sheets Formula Generator works
The builder generates common formulas locally in the browser. Locale-specific spreadsheet separators may differ.
Worked example
FILTER returns rows matching a condition; SUMIF and COUNTIF aggregate matches.
How to interpret the result
Formula behavior depends on ranges and your spreadsheet locale.
Common mistakes and limits
Check criteria ranges have compatible dimensions and locale separators.
Frequently asked questions
Why does my locale use semicolons?
Some spreadsheet locales use semicolons instead of commas as argument separators. Replace separators if required by your locale.
Important note
WorkTools provides general-purpose informational calculations. Verify inputs, definitions, policies and jurisdiction-specific requirements before using a result for financial, payroll, legal or other consequential decisions.