hello,

i'm having difficulty with this formula. in column L i have a list of identification numbers including some multiples. in column F is "yes" or "no" depending. i'm trying to create a summary of how many No's appear for each identification number on a different sheet. i hope this is enough information, let me know if i need to elaborate more.


Thanks,