Search tools

Search for a command to run...

Excel & Google Sheets Formula Generator

Build Excel and Google Sheets formulas without memorizing syntax — SUMIF, COUNTIF, XLOOKUP, IF, date differences, TEXTJOIN, UNIQUE and more. Pick a task, fill in your cells, copy the formula.

How to use

  1. 1Pick what you want to do.
  2. 2Enter your cell references and values.
  3. 3Copy the formula into your spreadsheet.

Frequently asked questions

Do these formulas work in Google Sheets?

Yes — all of them work in Google Sheets. XLOOKUP, TEXTJOIN, UNIQUE, TEXTBEFORE and TEXTAFTER need Excel 2021 or Microsoft 365 on the Excel side; choose the older-Excel option where offered.

What should I type as a condition?

A value (Paid), a number (100), a comparison in quotes-free form (>=100, <>0) or a cell reference (E1). The generator adds quotes where Excel needs them.

Why add $ signs to ranges?

$B$2:$B$50 stays fixed when you copy the formula down; without $ the range shifts row by row.