Formula help

[=?iso-8859-1?B?QW5kcuk=?=]

I have this formula in cell A3
=IF(ISBLANK(D3),"",A2+1)
is there a way to set it up so that if there is text in
cell D3 not only will it give me my A2+1 but that in cell
A4 the formula =IF(ISBLANK(D4),"",A3+1) would appear, and
so on and so forth?

Tks.
A.

 

[Sandy Mann]

André,

I don't really understand what it is you are asking because with the
formulas in the cells that you state you will get a result if the cells in
Column D are filled in in chronological order. If not you will get a
#Value! error. If you want the count to continue even with gaps then:

=IF(ISBLANK(D3),"",IF(ISNA(LOOKUP(9.99999999999999E+307,$A$2:A2)),0,LOOKUP(9
..99999999999999E+307,$A$2:A2))+1)

in cell A3 and copied down will continue the count even if there are gaps.
However, in that case the far simpler:

=IF(ISBLANK(D3),"",COUNTA($D$13))

in A3 and copied down will do the same thing.

HTH

Sandy

 

[Sandy Mann]

André,

I don't really understand what it is you are asking because with the
formulas in the cells that you state you will get a result if the cells in
Column D are filled in in chronological order. If not you will get a
#Value! error. If you want the count to continue even with gaps then:

=IF(ISBLANK(D3),"",IF(ISNA(LOOKUP(9.99999999999999E+307,$A$2:A2)),0,LOOKUP(9
.99999999999999E+307,$A$2:A2))+1)

in cell A3 and copied down will continue the count even if there are gaps.
However, in that case the far simpler:

=IF(ISBLANK(D3),"",COUNTA($D$13))

in A3 and copied down will do the same thing.

HTH

Sandy
--

Your use of =IF(ISBLANK(A3), made me assume that the entries in Column D
were direct entry data items. If there is any possibility that there could
be formulas returning an empty string, ("") then use =IF(A3="","", instead.

Sandy