Back to prompts
Data & Analysisbeginner
4.9

Spreadsheet Formula Wizard — Solve Any Excel/Sheets Problem in Plain English

Describe what you want to calculate and get the exact formula with explanation — from basic lookups to complex array formulas that would take hours to figure out.

Copy & Paste this prompt
You are an Excel/Google Sheets expert who has solved 10,000+ spreadsheet problems. Help me build the exact formula I need.

My Situation:
- Tool: [Excel / Google Sheets / Both]
- What I'm trying to do: [DESCRIBE IN PLAIN ENGLISH]
- My data looks like: [DESCRIBE YOUR COLUMNS]
- Data range: [e.g., A1:D500]
- Any conditions/filters: [SPECIFIC CRITERIA]
- Expected output: [What should the result look like?]

Provide:

**1. THE FORMULA**
```
=YOUR_FORMULA_HERE
```

**2. FORMULA BREAKDOWN**
Explain each part like I'm not a spreadsheet expert.

**3. STEP-BY-STEP SETUP**
- Where to put the formula
- How to copy/drag it correctly
- Any helper columns needed

**4. ERROR HANDLING**
- What errors might appear and why
- How to wrap it to handle blanks/errors gracefully

**5. ALTERNATIVE APPROACHES**
- Simpler version (if one exists)
- More powerful version (for expansion)
- Pivot table approach (if easier)

**6. BONUS: MAKE IT DYNAMIC**
- Add dropdowns/filters
- Auto-expand as data grows
- Dashboard-ready version
#excel#google-sheets#formulas#spreadsheet#data

Works with

chatgptclaudeany

💡 Pro Tips

  • •Always describe your data structure — column names matter
  • •Ask follow-up: 'Make this into a dashboard with dropdown filters'
  • •SUMIFS > SUMPRODUCT for most conditional sums

✨ Example Output

📋 REQUEST: 'Sum sales for each rep, only closed deals over $10K in Q3'

✅ THE FORMULA:
```
=SUMIFS(C2:C500, A2:A500, G2, C2:C500, ">10000", B2:B500, ">="&DATE(2024,7,1), B2:B500, "<="&DATE(2024,9,30), D2:D500, "Closed")
```

📖 BREAKDOWN:
- C2:C500: The amounts to sum
- A2:A500, G2: Only this salesperson
- C2:C500, ">10000": Only deals over $10K
- Date range: Q3 (July-September)
- D2:D500, "Closed": Only completed deals

🧠 Why This Works

Spreadsheet formulas are a language most people don't speak fluently. This prompt lets you describe your problem in plain English and get back the exact formula with a clear explanation.

📅 When to Use This Prompt

Whenever you need a formula you can't figure out, when building reports, or when you know what to calculate but not which functions to use.

🎯 What You'll Get

The exact formula you need, explained in plain English, with error handling and alternatives.

🔗 Related Prompts