Hi,
I have been using the following formula successfully just by changing the names. For example I can change it from "Jennifer" to "Michael" to obtain my data successfully.
=SUMPRODUCT(--('Paste Query Results Here'!$A:$A="Jennifer"),--('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)))
However, I need to be able to change my formula to pull data for everyone else than my main 8 names. I tried this but it didn't work:
=SUMPRODUCT(--('Paste Query Results Here'!$A:$A<>"Michael","Reggie","Jennifer","Hortencia","Matthew","Amanda","Alex","Virginia),--('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)))
Please help! What am I doing wrong or missing? Your assistance would be greatly appreciated.
Bookmarks