Hello, I have a simple application which retrieves a list of users from
an Active Directory, and exports it to an Excel file.

Each user is on a row with columns A-E containing name, user name,
department and a few other columns. Column F and the successive columns
contain the groups the user is member of - one group name per cell.

By using COUNTIF on the department column, I can easily find out how
many users are in a given department. Similarly, by using COUNTIF on
columns F-IV, I can count how many users are in a given group (assuming
each user only can be member of the given group once, which is a safe
assumption to make).

However, I'm having some trouble with the next calculation: How do I
count the number of users _in a given department_ who are members of a
given group? I can solve this by making auxiliary columns containing a
formula, but is it possible to solve by having the entire formula in a
single cell? (this calculation needs to be done for a lot of departments
and groups, so something other than a single-cell solution would get messy).

I appreciate any input!



Regards,
Nils Magnus