How to increase the value in one cell by 1 after adding a value in each cell of another column

[kkaass]

Hi,

I would like to ask a question regarding the use of IF statement.

So basically, in column A I have serial numbers and this column is known as 'Serial No'. What I really want is that in just one cell B2, the value becomes equal to the value added in each additional cell of column A.

So for example, in A2 when I add value 1, B2 should have the value 1, when I add value 2 in A3, B2 should have the value 2, when I add value 3 in A3, B2 should become 3 and so on.

So whenever I enter a number in each additional cell of column A, the cell B2 should become equal to the number added in the latest cell of A. I can't use a 'range' in this case for A because it is not confirmed how many cells in column A will be filled out, its not fixed.

There might be a simple answer to this, but I just can't seem to figure out. Any help would be greatly appreciated.

 

[kkaass]

Thank you for the answer JoeMo!
Something like this:

A
Observer1 1 (in Cell B2)
Observer2 2 (in Cell B2)
Observer3 3(in Cell B2)
Observer4 4(in Cell B2)

So as soon as I enter text in each cell of Column A, the 'number' in cell B2 increments by 1. Somehow it detects that text has been added in an additional cell of A, and the number in B2 increments by 1.

I think the statement that you mentioned is like that.