spot_img

How To Increment Row Number In Formula In Excel

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 a data like this:

 

data tableYou 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 columnProof 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.second formulaNote: It is better to only stick to 3, because after the third it will be showing the same number over and over again.increment row formulaIn conclusion, after following those two steps, you should have something like this.

Template

You can download the Template here – Download
Further reading: 
Basic concepts 
Getting started with Excel
Cell References
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR