Bob Phillips wrote...
=COUNTA(D:D)-COUNT(D:D)
....

Picky: that'd include cells evaluating to errors and booleans in the
count. It'd also include cells evaluating to "".