I've been asked to create an excel spreadsheet for one of the directors, it contains a list of all the names and divisions of each staff member. It needs to count the number of staff in each department but only if they appear on the roster.
Name Divison On Roster
Joe Bloggs IT Yes
John Smith HR No
I have a formula to count the number of occurrences of each division, the current formula I have is:
I want it to respect the 3rd column (column C) and only count the value of "Division" if "On Roster" is "Yes".
Any ideas? Thanks!