Count blank cells in filtered table when every column has empty cells

[drom]

Hi and thanks in advance

I have a table with 9 columns.

Any of the columns within the table has every row/cell with info
i mean some times the cells are empty within the different columns.

If I filter my Table "Table1" according to column A, B and C

I would like to count how many blank cells are within my filtered table in column D.

I was trying to adapt this

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A5:A200,ROW(A5:A200)-ROW(A5),,1)),--(D5:D200=""))​

But I can't use A:A200 since any column has always data.

Any Help ?

ps: I do not want to use/add one more Column to update the above formula
J5= rand() and then:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(j5:j200,ROW(j5:j200)-ROW(j5),,1)),--(D5:D200=""))​

I would like to use references to just one Column the Column D

 

[drom]

Re: Count balnk cells in filtered table when every column has empty cells

=SUMPRODUCT((COUNTIF(j5:j200;j5:j200)=1)*1;(SUBTOTAL(103;OFFSET(J5;ROW(j5:j200)-MIN(ROW(j5:j200));0)))*1) for Duplicates in filtered table
=SUMPRODUCT((COUNTIF(j5:j200;j5:j200)>1)*1;(SUBTOTAL(103;OFFSET(J5;ROW(j5:j200)-MIN(ROW(j5:j200));0)))*1) for Uniques in filtered table