Skip to content

No account required

Start a project

Excel formula generator

Describe the calculation. You get the formula, how it works, and what it assumes about your sheet.

Plain English. The way you would explain it to a colleague.

Optional, and the single biggest difference between a usable answer and a generic one.

A worked example

“Add up column D, but only the rows where column B says London”

=SUMIF(B2:B1000,"London",D2:D1000)

SUMIF walks down column B looking for the word London, and adds the matching cell from column D each time it finds one. The two ranges have to be the same height or the rows stop lining up.

What it assumes

  • Assumes your data starts in row 2 and ends by row 1000. Widen both ranges together if it grows.
  • Matches "London" exactly. A row reading "London, UK" or " London" with a leading space is not counted.
  • Returns 0 rather than an error when nothing matches, so an empty result and a genuine zero look identical.

01

It tells you what it assumed.

Which row your data starts on, what it returns when nothing matches, what happens to blank cells. That is the half of the answer that decides whether the number you paste into a report is right.

02

It stays inside the Excel you have.

XLOOKUP, LET and FILTER only exist in Microsoft 365 and Excel 2021. When one of them is the clean answer, you get it and a note saying so, with the INDEX and MATCH version that works everywhere else.

03

Nothing runs anywhere.

The formula comes back as text for you to copy. No file is uploaded, nothing is executed, and there is no account to make.

Questions people ask

Does it work with my version of Excel?

It targets Excel 2019 and later by default. When the natural answer needs a function that only Microsoft 365 and Excel 2021 have, such as XLOOKUP or FILTER, you are told in a caveat and given the older construction that works in every version.

Do I have to upload my spreadsheet?

No, and there is nowhere to. You describe the calculation, optionally list your column headings, and the formula comes back as text. Nothing about your file leaves your computer, because the file never leaves it.

Why does every answer come with caveats?

Because a formula without them is half an answer. Most spreadsheet errors are not typing mistakes, they are a formula quietly doing the wrong thing at the edges: ignoring the row your data actually starts on, returning zero when it found nothing, or matching a value that has a trailing space. Those are the things the caveats name.

Is it free?

Yes, and there is no account. There is a limit on how many you can generate in an hour, which exists to stop scripts rather than people.

When it is a whole file

A formula fixes one column. If what you actually have is four exports and a question, drop them here and you get the cleaned data, the analysis and the charts back.

No account needed to start. You only pay when you like what you see.