← All free prompts
Spreadsheets · 3 min

Get Spreadsheet Formulas Without the Headache

Describe what you want in plain words. Get the formula and how it works.

Use it whenYou're stuck on an Excel or Google Sheets formula.
You'll needYour column names, a few sample rows, what you want to calculate.
Get your stuff inAttach the spreadsheet, or take a screenshot showing the column headers and 5-10 rows. Remove sensitive names first.
  1. Copy the prompt below.
  2. Paste it into a new chat in ChatGPT, Claude, Gemini or Copilot.
  3. Replace the [orange] parts with your details, then press Enter.
COPY-PASTE PROMPT
You are a patient spreadsheet expert.
TOOL: [Excel / Google Sheets]
MY COLUMNS: [e.g. A = Date, B = Customer, C = Amount]
SAMPLE ROWS: [paste 5-10 rows, or attach the file]
WHAT I WANT: [e.g. total sales per customer per month]
1. Give me the exact formula (or pivot table steps) for my tool.
2. Tell me which cell to put it in and how to copy it down.
3. Explain in plain words what each part does.
4. Show the result you'd expect for the sample rows, so I can check it works.
5. Warn me about common errors (blank cells, numbers stored as text, dates).
6. Add a check formula that warns if any amount is blank or stored as text.
If my request could mean two things, state your assumption first.
RULES: Use only the facts I give you. Don't invent names, figures, dates, owners or commitments. Calculating is fine; label estimates and proposals. Mark anything uncertain as [CONFIRM]. List empty required fields under 'Missing info' and continue (skip optional ones). Keep it concise.
EXAMPLEA = Date, B = Customer, C = Amount. Rows: 03/10 Acme 120, 14/10 Acme 80, 28/10 Acme 50, 29/09 Acme 70, Brightline '90' (text). Names in column E; October totals, please.
WHAT YOU GETIn F2: =SUMIFS(C:C, B:B, E2, A:A, ">="&DATE(2026,10,1), A:A, "<"&DATE(2026,11,1)), then drag down. Acme = 250 (September excluded). Brightline's '90' is text: it counts as 0.
Make it better. Type this next:

"Now turn it into a summary table that updates automatically when I add new rows."

Check before you use it

Test the formula on rows where you know the answer.

Use sample rows, not sensitive customer data.

"Ask for the formula. Check it on a few rows."Vince Marlow

This prompt is one step. The kit is the whole job. The AI Work Kit turns 25 work tasks into complete workflows: a worked example for each, what to check before you send, what to do when AI gets it wrong, and editable Word and Excel templates.

Get The AI Work Kit · $19 See what's inside
Free · Instant download

Five of Vince's most useful work prompts, in one PDF

Ready to print or keep on your desktop. Copy, paste, done.