AI KUNST
More free tools

Excel Formula Generator

Choose what you want to calculate, fill in your cells and copy a working formula — no function names to remember.

What do you want to do?

Range to add up
Conditions

Your formula

=SUMIF($A$2:$A$100,"East",$C$2:$C$100)

What it uses

Range to add up
'C2' to 'C100'
Conditions
'A2' to 'A100' · is "East"

Functions used

SUMIF
Adds up cells that meet one condition.

Translate or explain a formula

Paste a formula to see the functions it uses and get it with the function names and separator chosen above.

How to use the formula generator

  1. Choose your spreadsheet. If your Excel is 2019 or older, formulas use only functions it has.
  2. Pick what you want to do and type your ranges and values. Text, numbers and cell references are handled for you.
  3. Copy the formula and paste it into a cell. Use the translator below to switch function names between languages.

Frequently asked questions

Does it work with Google Sheets?

Yes. Choose Google Sheets as the spreadsheet: the formulas use functions Google Sheets supports, such as XLOOKUP and TEXTJOIN.

Why does my Excel show #NAME?

Your Excel doesn’t know one of the functions, or the names are in a different language. Choose “Excel 2019 or older”, or set the function names to your Excel’s language.

When should I use “;” instead of “,”?

Excel in many European languages uses a semicolon between arguments and a decimal comma. If a pasted formula is rejected, switch the separator.

What does $ in A$2 mean?

It locks the row or column so the range stays the same when you copy the formula to other cells. Turn on “Lock ranges” for lookups and conditional sums.