technician12
09-21-2020, 12:52 AM
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 ?
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 ?