Hello


I'm using this formula to number the amount of cells in $D$9;D500 with data in them:
=IF(SUBTOTAL(3;$D$9:D9)=C8;"";SUBTOTAL(3;$D$9:D9))
But the formula does not ignore cells with 
=""
in them, as they're technically not empty, anyone know a way without VBA to resolve this ?