Count IF formula with 2 dependent variables - Unsure how to construct

[nscarritt]

I am working on an excel structure to count the number of new associates we get per start date based on two criteria: The Venue they will work on, and the organization they'll be working in. The Hierarchy is such that Each Org has all the venues, and the associate will be assigned to a venue within a org.

I want to capture about 5 orgs, and then have an "Other" categorey for the rest.

I am also looking to do a separate count function based on certain roles, also including an "Other".

I am attaching a spreadsheet with an example of the data that we get from our HR department, a sample of our current manual spreadsheet, and a outlined workflow that I'm hoping to accomplish.

I am having trouble with figuring out how to use if statements on more than just a basic level, so I'm sorry to be asking such a large question.

Any help would be incredible!

Onboarding Example.xlsx

[Brendan_Floyde]

http://office.microsoft.com/en-gb/ex...010047494.aspx


I think countifs (see link) is what you are after.

Or you might like to think about using a pivot table to summarize your data.