Gallery
# 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

CategoryData
Made byCasama
VersionVersion 1 · updated November 13, 2026
AddedNovember 13, 2026
LicenseApache-2.0
SourceOn GitHub
Add a badge to your README

Add to Casama

Markdown

[![Add to Casama](https://gallery.casama.ai/badge.svg)](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>

More skills