Coding · Spreadsheets

Write an Excel or Google Sheets Formula

Get a ready-to-paste formula for your spreadsheet, with a simple explanation of how each part works.

Prompt Code output

I use [SPREADSHEET_APP] and I am not an expert. I need a formula that does this: [GOAL]. Here is how my sheet is laid out (which column holds what, and which row the data starts on): [SHEET_LAYOUT]. Please give me one formula I can copy, and tell me exactly which cell to click before I paste it. Then explain each piece of the formula in plain words, as if to a friend who has never written one. If there is a simpler way to get the same result, show that too. Finally, tell me what to check if the formula shows an error or a strange number.

Fill in the brackets

[SPREADSHEET_APP]
Excel, Google Sheets, or LibreOffice Calc
[GOAL]
What you want the formula to do, e.g. total sales per month for each shop
[SHEET_LAYOUT]
e.g. column A = date, column B = shop name, column C = amount, data starts on row 2

How to use

  1. Copy the prompt.
  2. Replace the text inside [BRACKETS] with your own details.
  3. Paste it into ChatGPT or another AI assistant.
  4. Read the result and ask for changes if needed.

Tip: Describe your columns as precisely as you can; the more exact the layout, the less you will need to adjust the formula.