Countif if counting 65536 cells (excel 2003) with count if blank

To count rows where column J is populated but K isn't try using SUMPRODUCT like this

=SUMPRODUCT((Active!J$10:J$65536<>"")*(Active!K$10:K$65536=""))

If you don't really have 65527 lines of data then it would be better to use a smaller range