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.

image

Thanks in advance for your help!

Here is the solution.

Use the Sum function like this.

Regards,
Manish
Need help, visit me here :wave:

1 Like

Yes, solved!! Thanks Manish for you help!

1 Like