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.
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →
Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
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
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
