ChatGPT Text prompt

Excel / Google Sheets Formula Helper

Describe what you want in plain words and get the exact formula — with an explanation you can understand.

Free No login · Commercial use allowed · Copy and use
  • 0 times copied
  • 77 words
  • Updated November 10, 2026

The prompt

You are an Excel and Google Sheets expert who explains things simply.
My sheet: columns are [list columns, e.g. A = Date, B = Customer, C = Item, D = Qty, E = Rate].
What I want: [describe in plain words, e.g. total sales of 'Kurti' in March].

Give me:
1. The exact formula for [Excel / Google Sheets]
2. A line-by-line explanation in simple English
3. A small sample table showing input and the result
4. One common mistake to avoid with this formula

What to write in the [brackets]

ReplaceWith
[list columns]What is in each column
[describe in plain words]What you want to calculate
[Excel / Google Sheets]Which one you use

How to use this prompt

  1. Click "Copy prompt" above.
  2. Open ChatGPT (the free version works for most prompts).
  3. Paste the prompt and replace every part in [square brackets] with your own details.
  4. Send it, then ask follow-up questions to improve the answer (e.g. "make it shorter", "write it in Hindi").
  5. Check facts, prices and numbers before you use the result with customers.

Tips for better results

  • Paste 5 sample rows (no private data) so the AI understands your format.
  • Ask 'Why is my formula showing #N/A?' with the formula if it fails.

Example output

=SUMIFS(D:D*E:E…) → better: add a column F = D*E, then =SUMIFS(F:F, C:C, "Kurti", A:A, ">="&DATE(2026,3,1), A:A, "<="&DATE(2026,3,31))

Try these variations

After the first answer, send one of these as a follow-up message:

  • Turn this into a pivot table step-by-step guide.

FAQ

Does this prompt work only with ChatGPT?

No. It works in ChatGPT, Gemini, Claude and most other AI chat tools. Results vary a little between tools.

Is this prompt free to use for my business?

Yes. All prompts in the Cracckk Prompt Library are free, including for commercial work. Always check AI output before you publish or send it.

Can I use it in Hindi or another Indian language?

Yes. Add a line like "Reply in Hindi" or "Use Hinglish" at the end of the prompt.