(Question) Make Subtotal ignore ="" Cells

Hello


I'm using this formula to number the amount of cells in $D$9;D500 with data in them:

Code:

---

=IF(SUBTOTAL(3;$D$9:D9)=C8;"";SUBTOTAL(3;$D$9:D9))

---

But the formula does not ignore cells with

Code:

---

=""

---

in them, as they're technically not empty, anyone know a way without VBA to resolve this ?

No one :) ?