Home › Prompts › Gemini › Spreadsheet formula builder

Spreadsheet formula builder

Get the exact Google Sheets or Excel formula for a task, explained, with an example.

GeminiData analysisRuleStack original

Written for Gemini 4 Argon (Gemini in Sheets) · Updated 2026-10-16

Note: Review and test before use. Provided as is, without warranty. See Terms.

Prompt

Download  
In [Google Sheets/Excel], my data: column A [contents], B [contents], C [contents], rows 2–[n]. I want to [goal, e.g. sum C where A is this month and B is "Paid"]. Give the formula, explain each part, and show the expected result for a 3-row example. Offer an alternative with QUERY/LET/LAMBDA if cleaner.

Replace everything in [square brackets] with your own details.

Settings & parameters

Variations

Tips

More: all Gemini prompts · all data analysis prompts · prompt library

Related prompts

Analyze a CSV and explain the findings

Upload a spreadsheet and get cleaning notes, key metrics, charts and plain-English findings with caveats.

ChatGPTData analysis

A/B test readout with statistical rigor

Interpret experiment results correctly: significance, effect size, power and practical recommendation.

ClaudeData analysis

KPI dashboard design

Define the right metrics, formulas and chart types for a business dashboard.

GrokData analysis

Code open-ended survey responses

Turn hundreds of free-text survey answers into themes with counts, quotes and recommendations.

Any chat AIData analysis

Get new rules weekly

One email a week: fresh rule files, agent tips, and what's changing in Cursor, Claude Code and Copilot. Free, unsubscribe anytime.

Opens the Rulestack Newsletter on beehiiv in a new tab. Or subscribe directly on beehiiv.