Summary
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.
Install to Claude Code
npx -y skills add composiohq/awesome-codex-skills --skill spreadsheet-formula-helper --agent claude-codeInstalls into .claude/skills of the current project.
Keeps your Mac awake while Claude Code, Codex or Cursor works. Lets it sleep when they are done.
Try free for 7 days →
Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →
Notes, actions and memory. Without a meeting bot. First month 100% off.
Download for free →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
Free an open-source skills that make AI coding agents easier to understand, verify, and control.
Download for free →
Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →Files
SKILL.mdView on GitHub
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.
Featured
Keeps your Mac awake while Claude Code, Codex or Cursor works. Lets it sleep when they are done.
Try free for 7 days →Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →Notes, actions and memory. Without a meeting bot. First month 100% off.
Download for free →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Free an open-source skills that make AI coding agents easier to understand, verify, and control.
Download for free →Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →
