Spreadsheet Formula Helper

You need a working SUMIFS or a gnarly array formula, and you need it to actually work in both Excel and Google Sheets without blowing up on edge cases. This skill walks through the full loop: it asks for your platform, separator style, sample data, then drafts formulas with named ranges and dynamic arrays where applicable. The workflow is methodical, restating your problem, explaining placement, and covering blanks, mixed types, and timezone quirks with IFERROR or LET guards. You get a worked example with 2-3 rows of input and output, plus optional troubleshooting for common mistakes. Honest take: if you've ever spent twenty minutes debugging why your VLOOKUP returns #N/A on row 847, this saves that time.

skills.sh installs: 243
GitHub stars: 12.8K
last updated: Jun 3, 2026

View on GitHub

Install

$ npx -y skills add composiohq/awesome-codex-skills --skill spreadsheet-formula-helper --agent claude-code

Installs into .claude/skills of the current project.

Files

Spreadsheet Formula Helper

Produce reliable spreadsheet formulas with explanations.

Inputs to gather

Platform (Excel/Sheets), locale (comma vs. semicolon separators), sample data layout (headers, ranges), expected outputs, and constraints (volatile functions allowed?).
Provide small example rows and the desired result for them.

Workflow

Restate the problem with explicit ranges and sheet names; propose a minimal sample to verify.
Draft formula(s); when dynamic arrays are available, prefer them over copy-down formulas.
Explain how it works and where to place it; include named ranges if helpful.
Edge cases: blank rows, mixed types, timezone/date quirks, duplicates; offer guardrails (e.g., IFERROR, LET, LAMBDA).
Variants: if porting between Excel and Sheets, provide both versions.

Output

Primary formula, short explanation, and a 2–3 row worked example showing inputs → outputs.
Optional: quick troubleshooting checklist for common errors.

SKILL.md on GitHub