count blank cells only if a 1 is previous

[Directlinq]

Hi
I need help getting a formula to do this
I have
......D E
5 )......1
6 )......2
7 )......3
8 )......4
9 )......5
10)......6
11)......7
etc down to 31

They only show up when the cell next to it is not empty.
=IF(ISBLANK(D5),"0",(1))
=IF(ISBLANK(D6),"0",(2))
etc

If nothing is put into say D5 D6 or D7 but something is put in D8 then i would like E8 to become 1 as it is the first to be filled.Then when D9 has something in it, it becomes 2
if D10 has nothing in it it gets left blank but when d11 has something in it e11 becomes 4 counting the blank cell in between.
How can this be done.

Any help would be great
Thanks

[JBeaucaire]

How about:

=IF(ISBLANK(D6),0,E5+1)

No "quotes" around numbers. Copy that down, it should do what you wanted.

[Directlinq]

This works but if a cell is skipped it starts from 1 again and does not count the blank cell.

......D E
5 )......1
6 )......2
7 )......3
8 )......4
9 )......5
10)......6
11)......7
etc down to 31

If D10 has nothing in it E10 gets left blank but when d11 has something in it E11 becomes 4 counting the blank cell in between.

[JBeaucaire]

This works but if a cell is skipped it starts from 1 again and does not count the blank cell.

......D       E
5             1 
6             2
7             3
8             4
9             5
10            6
11            7
etc down to 31

If D10 has nothing in it E10 gets left blank but when d11 has something in it E11 becomes 4 counting the blank cell in between.

If you put [code] tags around stuff it will line up legibly.

Looking at your sample above, there is no clear reason why E11 would be 4?

[Directlinq]

.....D        E
5    1        1 
6    1        2
7    1        3
8    1        4
9    1        5
10   1        6
11   1        7
etc down to 31

If D5 D6 and D7 are left blank i would like this to happen which it does with this formula
=IF(ISBLANK(D6),0,E5+1)

.....D        E
5             0 
6             0
7             0
8    1        1
9    1        2
10   1        3
11   1        4
etc down to 31

If D5 D6 D7 and D10 has nothing in it E10 gets left blank but when d11 has something in it E11 becomes 4 counting the blank cell in between.

example 1

.....D        E
5             0 
6             0
7             0
8    1        1
9    1        2
10            3
11   1        4
etc down to 31

example 2

.....D        E
5    1        1
6             2
7             3
8    1        4
9    1        5
10            6
11   1        7
etc down to 31

example 3

.....D        E
5             0
6             0
7    1        1
8             2
9    1        3
10            4
11   1        5
etc down to 31

the counting starts from the first 1 in the E column

Sorry about the confusion.
Many Thanks

[JBeaucaire]

will it always be 1s in that column D?

[Directlinq]

No 1 is just an example of that cell being filled (notblank)
Thank you

[DonkeyOte]

so isn't it just

E5: = N(E4)+(COUNTA(D$5:D5)>0)

[DonkeyOte]

in reality... to avoid COUNTA repeatedly looking at the same range over and over...

E5: =N(E4)+OR(N($E4),D5<>"")

[Directlinq]

Perfect spot on
Thank you