A measured SEQUENCE gallery: sums, grids, steps and date ranges, every value engine-verified. Live, editable, free.
Fills row-major (across each row, then down). Excel 365/2021+ only. Wrap in INDEX for one element, SUM for a series total, or add to DATE for a calendar.
SEQUENCE(rows,[columns],[start],[step]) spills a grid of numbers — the building block for test data, indices and calendars. Every result below was measured live in the engine. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =SUM(SEQUENCE(5)) | 15 | Sum of 1..5 |
| =INDEX(SEQUENCE(5),3) | 3 | Third element of 1..5 |
| =SUM(SEQUENCE(4,3)) | 78 | Sum of a 4×3 grid (1..12) |
| =INDEX(SEQUENCE(3,2,10,5),1) | 10 | First element, start 10 step 5 |
| =ROWS(SEQUENCE(7)) | 7 | Spill has 7 rows |
| =SUM(SEQUENCE(10,1,1,2)) | 100 | Sum of first 10 odd numbers |
| =SUM(SEQUENCE(100)) | 5050 | Sum of 1..100 |
| =INDEX(SEQUENCE(5,1,2,2),4) | 8 | 4th even number from 2 |
| Expression | Result | Why |
|---|---|---|
| =SEQUENCE(5) | 1,2,3,4,5 | rows only — a vertical 1-5 spill, start 1 step 1 |
| =SEQUENCE(4,3) | 4×3 grid 1..12 | rows fill first, then columns (row-major) |
| =SEQUENCE(3,2,10,5) | 10,15 / 20,25 / 30,35 | start 10, step 5 |
| =SEQUENCE(10,1,1,2) | 1,3,5..19 | odd numbers (step 2) |
| =SEQUENCE(5,1,2,2) | 2,4,6,8,10 | even numbers from 2 |
Edit the Sales column; SUM-based presets update. SEQUENCE generates from its arguments, independent of the grid.
10 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
SEQUENCE is Excel 365/2021+ only; older Excel returns #NAME?. Google Sheets and Excel for the web support it.
| Platform | Support | Notes | Gotcha |
|---|
SEQUENCE is one piece. The full course walks the toolkit end to end with live, measured examples.