Automatic Numbering

[JJ in SD]

Good Evening,

In cell A12 I have =IF(ISTEXT(B12),1,"") Results in 1
In Cell A13 I have =IF(ISTEXT(B13),A12+1,"") Results in 2
In Cell A14 I have =IF(ISTEXT(B14),A13+1,"") Results in 3, Ok so far. This goes on for 100 lines.

If I delete the text from Cell B13, A13 goes blank and of course I get #VALUE! from A14 and beyond.

How do I change (if possible) the formula so B13 just goes blank and Cell A14 becomes 2 and the numbers carry on.

Thanks in advance,

JJ in SD

 

[dave3009]

Try like this in A13

=IF(ISTEXT(B13), COUNT($A$12:A12)+1, "")

copy down

 

[JJ in SD]

Thanks Dave, You are a "Star"