Formula to count mixed Text

Looking for a formula to do a count of column D. My best attempt so far is column E. I need a count that does not repeat as shown in column G.

Jim O

Looks like you want a progressive total?

Try this...
=IF($D3="",0,COUNTIF(D$3:D3,D3)+MAX($E$2:E2))

So close.

=IF($D3<>"",COUNTIF(E$2:E2,">"&0)+1,0)

Ford,

Thanks very much. That is what I was looking for.

Jim O

PS
daffodil11,
I did not see your post before I posted. I like that solution better.

Thanks to both of you.

Jim O