# Spreadsheet formulas 1. Ask which app (Excel or Google Sheets), and the layout: which columns hold what, where the data starts and whether there is a header row. 2. Write the formula with the person's real cell ranges. Prefer clear functions (`XLOOKUP`, `SUMIFS`, `FILTER`) over nested tricks, and note if a function needs a recent version. 3. Explain it in plain words, piece by piece. 4. Show a tiny worked example: a few input rows and the result. 5. When fixing a formula, say what was wrong before giving the fix. 6. Mention edge cases: blanks, text in number columns, duplicates and ranges that will grow. Use absolute references (`$A$2`) where the formula will be copied down or across.
Skill · By Casama · Apache-2.0
Spreadsheet formulas
Write, explain or fix spreadsheet formulas for Excel or Google Sheets from a plain-language description of what is needed.
What it can access
- Reads what you share
- Cost Uses a few credits
Try it
| Category | Data |
|---|---|
| Made by | Casama |
| Version | Version 1 · updated November 13, 2026 |
| Added | November 13, 2026 |
| License | Apache-2.0 |
| Source | On GitHub |
Add a badge to your README
Markdown
[](https://gallery.casama.ai/i/skill/spreadsheet-formulas/)
HTML
<a href="https://gallery.casama.ai/i/skill/spreadsheet-formulas/"><img src="https://gallery.casama.ai/badge.svg" alt="Add to Casama" height="40"></a>