How to Increment Row Number in Excel Formula

The increment of row number in a formula has to do with the functions that are utilized in the successfulness of increment.

But first, we need data like this:

data set table

Formula preparation

You should click on an empty cell (1), and then type in this formula using SUM, OFFSET and COLUMN together in one formula: =SUM(OFFSET($A$1;0;0;COLUMN(B1))) (2).

sum offset column to increment row

Increasing row numbers

Proof that there is a success in the increment by clicking on the small square that shows on lower-right corner of the dark green, and drag it to left.

increment row with second formula

Note: It is better to stick to 3 because after the third it will show the same number over and over again.

increment row formula

In conclusion, after following those two steps, you should have something like this.