Excel · Google Sheets · WPS

Describe it. Get the formula.

Type what you need in plain language. Copy a formula that runs in your spreadsheet. Free to start — 10 formulas a day after you sign up. History is kept for 30 days.

Try it free See pricing
  • Excel / Sheets / WPS
  • 10 free formulas a day
  • 30-day history
  • No file uploads

Formula studio

Try these

Platform

Guests get 1 free tries per day.

Result

Your formula will appear here, ready to paste.

Community

Formulas shared by members

Copy a formula someone else published. After 10 different signed-in users copy it, the author earns extra credits.

Excel 365 by jiayou

计算A列大于100的B列总和

该公式计算A列中大于100的所有对应B列值的总和。SUMIFS函数允许我们根据一个或多个条件对范围进行求和。这里我们指定条件为A列单元格值大于100，然后对满足条件的B列值进行求和。

=SUMIFS(B:B, A:A, ">100")

Likes and uses count only for signed-in accounts. Fake clicks from the same person are ignored.

Free · no credits

24 ready-made formulas to copy

No AI call, no daily quota. Sums, lookups, unique lists, dates, and working days. Use “Adapt to my sheet” when you need different columns.

Excel · WPS · Sheets

Sum between two dates

Sum amounts in B where dates in A fall in 2024

=SUMIFS(B:B, A:A, ">="&DATE(2024,1,1), A:A, "<="&DATE(2024,12,31))
Excel · WPS · Sheets

SUMIFS two conditions

Sum sales where region is East and product is Parts

=SUMIFS(C:C, A:A, "East", B:B, "Parts")
Excel · WPS · Sheets

Count values in a band

Count scores in B between 70 and 90 inclusive

=COUNTIFS(B:B, ">=70", B:B, "<=90")
Excel 365 / 2021

XLOOKUP exact match

Look up E2 in column A and return the name in C

=XLOOKUP(E2, A:A, C:C, "Not found", 0)
Excel 2016 · WPS

VLOOKUP for older Excel

Key must be the leftmost column; blank if missing

=IFERROR(VLOOKUP(E2, A:C, 3, FALSE), "")
Excel · WPS · Sheets

INDEX MATCH left lookup

Return a price from any column by product name

=INDEX(C:C, MATCH(E2, A:A, 0))
Excel · WPS · Sheets

IF with AND

High if status is Open and amount is over 1000

=IF(AND(C2="Open", B2>1000), "High", "Low")
Excel · WPS · Sheets

IFERROR instead of #N/A

Show a message when a lookup misses

=IFERROR(VLOOKUP(E2, A:C, 3, FALSE), "Not in catalog")
Excel 365 · Sheets

UNIQUE list

Distinct customer names in A, skipping blanks

=UNIQUE(FILTER(A2:A500, A2:A500<>""))
Excel 365 · Sheets

Count unique values

How many distinct names in column A

=COUNTA(UNIQUE(FILTER(A:A, A:A<>"")))
Excel 2019+ · WPS · Sheets

TEXTJOIN with commas

Join name, team, and email; skip blanks

=TEXTJOIN(", ", TRUE, A2, B2, C2)
Excel 365

First name from full name

Take the first word before the space in A2

=TEXTBEFORE(A2, " ")
Excel 365

Domain from email

ana@contoso.com → contoso.com

=TEXTAFTER(A2, "@")
Excel · WPS · Sheets

Age from birthday

Whole years of age from a birth date in A2

=DATEDIF(A2, TODAY(), "Y")
Excel · WPS · Sheets

Working days between dates

Weekdays between start and end, holidays in H

=NETWORKDAYS(A2, B2, H2:H20)
Excel · WPS · Sheets

Percent of total

B2 as a share of the column total

=B2/SUM($B$2:$B$100)
Excel · WPS · Sheets

Year-over-year growth

This year in B2, last year in C2

=IF(C2=0, IF(B2=0, 0, 1), (B2-C2)/C2)
Excel · WPS · Sheets

Last non-empty cell

Always return the latest filled value in A

=LOOKUP(2, 1/(A:A<>""), A:A)
Excel · WPS · Sheets

Overdue flag

Due date before today and status is not Paid

=IF(AND(C2<TODAY(), D2<>"Paid"), "Overdue", "OK")
Excel · WPS · Sheets

Round to nearest 0.05

Snap a price to nickel increments

=ROUND(A2/0.05, 0)*0.05
Google Sheets

QUERY select and sort

West region and amount over 500, sorted desc

=QUERY(A1:D, "select A, B, D where C = 'West' and D > 500 order by D desc", 1)
Google Sheets

ARRAYFORMULA fill-down

High if amount > 1000; leave new blank rows empty

=ARRAYFORMULA(IF(C2:C="", "", IF(C2:C>1000, "High", "Low")))
Sheets · Excel 365

FILTER a live list

List products that are East and Active

=FILTER(A2:A, (B2:B="East")*(C2:C="Active"))
WPS · Excel 2016

WPS SUMIFS

SUMIFS only — no 365-only functions

=SUMIFS(D:D, A:A, "East", B:B, "2024-03")
WPS · Excel 2016

WPS lookup, blank if missing

Keep printouts clean when a key is missing

=IFERROR(VLOOKUP(E2, A:B, 2, FALSE), "")

Change column letters after pasting. Nested or cross-sheet jobs still belong in the generator above.

How it works

Three steps to a working formula

No function names required. Describe columns, conditions, and the result — get a formula that starts with =.

1

Type what you need

Describe columns, conditions, and the result you want.

2

AI writes the formula

Functions stay within Excel, Sheets, or WPS for the version you picked.

3

Copy to your sheet

Every result starts with = and uses comma separators.

Excel · Google Sheets · WPS

Built for the spreadsheet you actually use

The same request is written differently per platform, so 365-only functions never land in older Excel or WPS.

Microsoft Excel

Excel 2016, 2021, and Microsoft 365 — including XLOOKUP fallbacks.

Google Sheets

QUERY, ARRAYFORMULA, and FILTER that fill as new rows appear.

WPS Office

Stays on SUMIFS, VLOOKUP, and INDEX. No 365-only functions.

We never upload your workbook. Only the prompt and formula are stored, and only for 30 days.

Guides

Popular formulas

All guides

News

Latest articles

All articles

FAQ

Before you start

Does this work in Excel, Google Sheets, and WPS?

Yes. Pick your platform before generating. The model avoids functions that app cannot run.

Is it free?

Guests get 1 trial(s). After you sign up you get 10 formulas a day.

Do you store my spreadsheet?

No. We only store the prompt and the generated formula, and only for 30 days.

How long are formulas kept?

Logged-in history is stored for one month, then deleted automatically by a daily cleanup job.

Are function names in English?

Yes. Formulas use English function names, which is what current Excel, Google Sheets, and WPS expect.

Write the next formula in under a minute.

Start free. Paste the result into your sheet. History deletes itself after 30 days.

Try it free