Add 1 to a cell on google sheet looking to the previous one SOLVED

Hi to everyone, i’m trying to add a row on a google sheet and take the previous value on A cell and adding 1 to it on the next row.

I.E. if on the row 20, the cell A has a value of 56, i want that the cell A value on the row 21 will be 57.

I try with the function serach cell and add row as below but it return 561 and not 57.
Seems that it add 1 not as addition but as 3th number.


Thanks in advance for your help!

Here is the solution.

Use the Sum function like this.

Need help, visit me here :wave:

Yes, solved!! Thanks Manish for you help!