You can ape the existing MATCH approach but simply convert the outer test from ISNUMBER to ISNA

=SUMPRODUCT(--ISNA(MATCH('Paste Query Here'!$A:$A,{"Michael","Reggie","Jennifer","Hortencia","Matthew","Amanda","Alex","Virginia"},0)),--('Paste Query Results Here'!$D:$D<>"NOT"),--('Paste Query Results Here'!$K:$K<>"K12"),--ISNUMBER(MATCH('Paste Query Results Here'!$D:$D,{"ADMIT","CANC","DENY","PEND","STU","WDRAW","CANCX","CANPX"},0)))
I'm pretty sure I've made the point previously but you should really be avoiding entire column references in SUMPRODUCT.

In the above (we must assume XL2007+ else it would not work) you're referencing/processing over 4 million cells...

Also (as previously mentioned I thin on other threads) the logic of your formula means the NOT test is superfluous given the subsequent MATCH test - removing it will save you a million cells
(ie it must be something other than NOT if it has passed the ISNUMBER(MATCH test...)