I am dealing with job applications for 8 different sites. People can apply for any combination of sites i.e 1 of them, 2 of them, all of them.

Some applicants have specifically said they don't want to apply for 1 or 2 particular sites.

I have used this formula `=COUNTIF(B1:B35,"*All*")`

to count when someone has specified 'all' sites or used site names to count each of the others.

I also have a tally for people applying to each site but now I want to subtract the numbers from the totals where people have specified NOT a particular site.

E.g applicant 1 applies for site A, applicant 2 applies for site site A & site B, applicant 3 applies for sites A, B and C, applicant 4 applies for all sites except A.

How do I count the applicants for 'All sites' or any of the others while also minusing applicant 4 from A's totals?

Hope I've explained this ok? Sorry if not.