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

ROW function

To increment the row number in an Excel formula, you can use the ROW() function, which returns the row number of the current cell. You can then use this value in your formula to reference cells in other rows.

For example, if you want to sum the values in cells A1, A2, A3, etc. in a column, you could use the following formula:


To increment this formula to sum the values in the next three rows (A2:A4, A3:A5, etc.), you can modify the formula as follows:


By using the ROW() function, you can make the formula dynamic, so that it automatically updates to include the correct range of cells, no matter which cell the formula is in:

See also  How to Use Vlookup to Check if Value Exists