Free Excel formula builder
Stop hunting through documentation. Pick what you want to do, fill in your cell ranges, and copy a correct Excel formula — SUMIF, SUMIFS, VLOOKUP, XLOOKUP, IF, IFS and more, with a plain-English explanation of what it does.
How it works
Correct syntax without the memorising.
Sum with a condition, look something up, branch on a test — in plain language.
Enter your ranges and conditions. Sensible examples are pre-filled so you can see the shape.
Get the exact formula with correct commas and quotes, plus a one-line explanation.
For nested, multi-step formulas built from your real columns, use the AI Excel formula generator.
FAQ
Do I need to know Excel syntax to use this?
No. You choose what you want to do in plain English and fill in the cell ranges; the tool writes the correct formula with proper syntax and commas.
Which formulas can it build?
SUMIF, SUMIFS, COUNTIF, AVERAGEIF, VLOOKUP, XLOOKUP, IF, IFS and TEXTJOIN — the everyday workhorses that cover most spreadsheet tasks.
Does it work in Google Sheets too?
Most of these formulas are identical in Google Sheets. XLOOKUP is available in current Google Sheets; the others (SUMIF, VLOOKUP, IF, TEXTJOIN) work in both.
What if I need a complex formula this doesn't cover?
For multi-step or bespoke logic, DataHub Pro's AI reads your actual columns and writes the full formula from a plain-English description — see the AI Excel formula generator.
Doing this on real spreadsheets, every week?
DataHub Pro turns any Excel or CSV file into dashboards, forecasts and a written report — automatically.
Try DataHub Pro free →