Your first Claude-written Excel formula, start to finish

You do not need to remember how to write a SUMIFS. Describe what you want to add up in plain English, paste ten rows of your data, and Claude writes the formula and explains it. Your part is the one thing it cannot do for you: checking the result against a total you already know.

This guide walks through one full loop with a made-up sales table you can paste as is. If you want the broader picture of Claude and spreadsheets, start with Claude for Excel. If you have never opened Claude, how to use Claude covers the basics.

The loop in three moves

Every formula request follows the same shape. Learn it once and it works for sums, lookups and filters alike.

Ten rows is plenty. Use your own numbers when you can, because the habit only sticks on a problem you have this week. The Free plan costs $0, so trying it costs nothing.

If you would rather attach a file than paste cells, Anthropic's upload page says: "Note: You must enable code execution and file creation in your account to upload XLSX files."

Try it: add up West sales for Q2

Here is the sample table. Copy it, paste it into a new chat, and add the request underneath. The columns are A to D, headers in row 1, data in rows 2 to 11.

Region	Rep	Quarter	Sales
West	Ana	Q1	1200
East	Ben	Q1	900
West	Ana	Q2	1500
South	Cara	Q2	700
West	Dev	Q2	800
East	Ben	Q2	1100
West	Dev	Q1	600
South	Cara	Q1	500
East	Eli	Q2	400
West	Ana	Q2	300

The request we added under the table:

Write a formula that adds up Sales for Region West in Quarter Q2. Explain what it does in plain English first, then give me the exact formula to paste into cell F2.

Asking for the explanation first matters. If Claude misread your columns, you see it in the plain-English part before a wrong formula lands in a live sheet. This is the reply, pasted from the run:

What it does: the formula checks every row for two things at once, Region is
West and Quarter is Q2, and adds up Sales only on the rows that pass both.

=SUMIFS(D2:D11, A2:A11, "West", C2:C11, "Q2")

How to read it: the first range (D2:D11) is the column to add up. Each pair
after that is a column to look in and the value to match.

On your ten rows, the matches are row 4 (1500), row 6 (800) and row 11 (300),
so F2 should show 2600.

One thing to watch: the ranges stop at row 11. If you add rows below, extend
them (for example D2:D100) or the new rows will not be counted.

Tested on Claude Sonnet (claude-sonnet-5-5), October 2026. We ran the prompt above on that model and pasted its reply unedited.

Check it before you trust it

Claude gave a total, so you have something to test. Do not skip this part, it is the whole skill.

We added the three rows by hand and got 2600, which is the total Claude stated. We did not open Excel for this run, so the formula itself was checked by that arithmetic and not by a live sheet. You should paste it into your own workbook and see the number appear there.

The last step is the useful one. If changing a value moves the total the way you expect, you understand what the formula counts.

Reuse the loop on the same table

Once the first formula works, change only the request and keep the table in the chat. Each variation below comes with the total we worked out by hand from the ten rows, so you know what to compare against. Ask Claude for the formula, run it, and see whether your sheet agrees.

• East in Q1. Only one row matches (Ben, 900), so the answer should be 900.
• All West sales, any quarter. Five rows match, and the answer should be 4400.
• Every Q2 sale, any region. Six rows match, and the answer should be 4800.

These come from our own arithmetic on the sample table, not from a new Claude run. If your sheet shows something else, the formula is wrong or the data was pasted wrongly, and that is the moment the check pays for itself.

Where Claude gets formulas wrong

Claude is a fast first draft, not a guarantee. Anthropic's help center says Claude "can occasionally produce responses that are incorrect or misleading" and that users "should not rely on Claude as a singular source of truth".

• It answers the question you asked, not the one you meant. If "Q2" is spelled differently in your real data, a formula that looks right can miss rows. Ask Claude which rows it counted and compare with your own list.
• Ranges are fixed. In our run the ranges ended at row 11, and Claude said so. A formula does not grow with your data unless you ask for that.
• The in-Excel add-in has its own limits. Anthropic lists it as "generally available to Pro, Max, Team, and Enterprise plans", and says data tables, macros and VBA are unsupported. Its advice: "Start with a trusted copy of the workbook before asking Claude to edit widely."
• Only use it on spreadsheets you trust. The same page warns that files from outside sources can contain hidden instructions that manipulate the add-in.

Common questions

Can Claude write Excel formulas from plain English?

Yes. In our run, one plain-English sentence produced a SUMIFS with an explanation, and the total Claude stated equals our hand count of 2600. Treat any formula as a draft: check it against a total you can work out yourself before it goes into a live model.

Do I need the Excel add-in to get a formula from Claude?

No. A chat is enough: paste cells or attach a file. The add-in is a separate option that Anthropic lists for Pro, Max, Team and Enterprise plans, and it works on your open workbook without leaving Excel. Setup is in Claude for Excel.

What do I do when the formula gives the wrong number?

Go back to the same chat and give Claude both numbers: what you expected and what Excel shows. Paste the formula and a few rows too, then ask which rows it counted. Compare its list with your own and the mismatch usually shows itself.

For more copy-paste requests like this one, see Claude prompts for work. claude/for is an independent guide, not run by Anthropic or Microsoft, and the product claims above link to Anthropic's own pages.