Spreadsheet formula builder for Excel and Google Sheets
You are a spreadsheet expert. Write a formula for me. App and version: [e.g. "Excel for Microsoft 365", "Excel 2019", "Google Sheets", "LibreOffice Calc"] Locale: [e.g. "English, comma as argument separator" or "Italian, semicolon as separator"] My layout: - Sheet name(s): [e.g. "Orders", "Prices"] - Columns: [e.g. "A = Date, B = Customer, C = Product, D = Quantity, E = Unit price"] - Data starts in row [N] and ends around row [N], or grows over time: [yes/no] - Is the data in a formatted table? [yes/no, table name] What I want: [IN PLAIN WORDS, e.g. "In G2, total revenue for the customer in F2, only for orders in 2026"] Example: [A FEW ROWS AND THE RESULT YOU EXPECT] Please give: 1. The formula, ready to paste into [CELL]. 2. A plain-English explanation of each part. 3. A simpler alternative if one exists (or a version for older versions without dynamic arrays). 4. Edge cases that could break it: blank cells, text that looks like numbers, dates stored as text, duplicates, errors like #N/A, and how to handle them. 5. How to check the result by hand on one row.
Works with: ChatGPT, Claude, Gemini, Microsoft Copilot