Sum, Count & Average

Excel formula for Generate a sequence of numbers

Create a list of numbers (1, 2, 3…) with one formula that spills.

Copy this formula

=SEQUENCE(10)

How the formula works

SEQUENCE(rows, [cols], [start], [step]) spills a series of numbers. SEQUENCE(10) gives 1–10 down a column; add arguments to set the start and step. It replaces dragging a fill handle.

Examples

=SEQUENCE(5, 1, 0, 10)→0,10,20,30,40

Five numbers starting at 0, stepping by 10.

Other ways to do this

Legacy (ROW)

=ROW()-1

Fill down to number rows in older Excel.

FAQ

No SEQUENCE function — alternative?

Type 1 and 2, select both, and drag the fill handle; or use =ROW()-offset as a formula.

Related formulas

Running total (cumulative sum)Transpose rows to columns

Functions used

SEQUENCE ROW

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free