Home / Prompts / Work / Excel / Google Sheets formula

Excel / Google Sheets formula

Say in plain words what you want to calculate and get a formula you can paste, with each part explained.

The prompt is put together in your browser. Nothing you type is uploaded, and favorites and history stay in your browser too.

Good for

Totalling sales for each salesperson
Pulling the month out of a date column for monthly totals
Comparing two sheets to find customers missing from one of them

1. Fill in the details

App required

What you want to calculate required

How the sheet is laid out optional

2. Adjust the options

Reply language

3. Copy the prompt

Where you will paste it

Cloud AILocal small model

ChatGPT, Claude, Gemini, DeepSeek and similar; the full, detailed prompt

Excel / Google Sheets formula

## Role
You are an Excel and Google Sheets expert who solves problems with the simplest, most maintainable formula.

## Task
I use Microsoft Excel (Microsoft 365). I want to: [Please add: What you want to calculate]

## Requirements
- The formula must work when pasted, using the cell references I described
- If there is a simpler way (such as a pivot table), mention it too

## Output format
Give the formula first (in a code block), explain each part in bullets, then show a small example of input data and the result.

If the information above is not enough to do the task, list the questions you need me to answer first. Do not make anything up.

A filled-in example

Fill it in like this. Press the button below to put the example into the form above.

App: Microsoft Excel (Microsoft 365)
What you want to calculate: Column B is the salesperson and column C the amount. I want each name in column F and their total in column G
How the sheet is laid out: Row 1 is headers; data runs from A2 to D500

What the AI's answer looks like

Illustrative excerpt: the real answer depends on the AI you use and what you fill in.

```
=SUMIFS($C$2:$C$500, $B$2:$B$500, F2)
```
- SUMIFS: adds up values that meet a condition
- $C$2:$C$500: the amounts to add
- $B$2:$B$500, F2: only rows where column B matches the name in F2

Fill G2 down to get each person's total. You can list the names in column F at once with =UNIQUE(B2:B500).

Tips

Say what each column holds and where the data starts so the formula works as is
Pick "older Excel" if that is what you use; it lacks newer functions such as UNIQUE and XLOOKUP
If the formula fails, paste the error code (such as #N/A) back to the AI

How to use it

Fill in the fields. You can leave a field empty for now; the prompt will show a [Please add] placeholder.
Choose the tone, length and where you will paste it, then press Copy.
Paste it into ChatGPT, Claude, Gemini, DeepSeek or a local model. If the AI asks you questions, answer them and the result gets better.