TextDesk
English
한국어English日本語简体中文Español

Excel and Google Sheets formula helper

Start with the worked examples, or describe your task and ask the AI for a formula. AI requests depend on the connection and a daily usage limit.

The AI helper is in a limited trial. If the usage limit is reached, only AI requests pause; the examples below keep working.

AI suggestions have not been run in Excel or Google Sheets. For important work, try them in a copy of your file first.

Start with an example

Each button shows a fixed, pre-checked example. It does not call the AI.

Ask the AI about your own task

Up to 1,500 characters. Mention columns, cell ranges and the result you want. Do not include names, contact details, salaries, account numbers, customer data or company secrets. Files cannot be uploaded.

AI requests leave your device.

The task or formula you type, the task type and the spreadsheet you picked are sent through Cloudflare to the Anthropic Claude API. Cloudflare Turnstile is used for the security check. Each provider may process what is sent under its own policy.

Opening this page or picking an example does not contact the AI or Turnstile. Existing ads and Cloudflare visit statistics are separate.

Type your task, give consent, then press the button.

Formula and explanation

A fixed, pre-checked example. Shown without calling the AI.

Formula

=SUMIF(A2:A4,"Delivered",C2:C4)

How it works

Picks only the rows whose status in column A is Delivered and adds the amount in column C on the same row. Keep both ranges the same height.

Sample input and result

A2=Delivered, C2=12000
A3=Shipping, C3=5000
A4=Delivered, C4=8000
Result: 20000

Things to check

A stray space before or after the status counts as a different value. Check the ranges against your real file.

What to include in your request

Instead of “make a total”, write something like “add C2:C100 for rows where A2:A100 says Delivered”, naming the condition column and the result column. Made-up values are fine; you do not need real customer or transaction data.

What formulas does it handle?

Everyday functions such as SUMIF, COUNTIF, IF, IFERROR, VLOOKUP and INDEX/MATCH on cell ranges. Formulas that read other files or web addresses, macros, named ranges and references to other sheets are not supported in this trial. Functions that only exist in Microsoft 365 may not work in older Excel.

Google Sheets mode

Choose Google Sheets to also use Sheets functions such as QUERY, FILTER, ARRAYFORMULA and REGEXEXTRACT. Functions that pull data from other files or the web, such as IMPORTRANGE, IMPORTXML, IMAGE and GOOGLEFINANCE, are never put in the answer.

Check before you copy

Make sure the ranges in the example match your sheet, then paste the formula into a new cell or a copy of the file. Depending on your regional settings, Excel may expect semicolons instead of commas between arguments. This page does not run Excel for you.

Privacy and limits

Your input and result are not saved in browser storage or the address bar. Nothing is sent until you give consent and press the button. Changing or clearing the input cancels the request on this page, but it does not undo anything already sent. If the usage limit is reached or the connection fails, the fixed examples still work.

AI regex generator · Clean up pasted lists · Case converter · Privacy policy

FAQ

Do the examples cost anything or call the AI?
No. The fixed examples are part of the page and do not call the AI.
Does Google Sheets use the same formulas as Excel?
Mostly, but not always. Pick Google Sheets in the menu so the answer can use Sheets-only functions like QUERY and ARRAYFORMULA and avoid Excel-only ones.
Is the answer always right?
No. The AI can misread a range or condition. Nothing is run here, so test the formula in a copy of your file.
Is everything processed on my device?
The examples are. AI requests are separate: after consent, what you type and your choices are sent through Cloudflare to Anthropic.
Why does it say the limit was reached?
The free AI helper has a daily usage limit to keep costs in check. The examples keep working; try the AI again the next day.