Cross Referencing With More Than One Variable?

EDIT: Original attachment had a formula error -see FIXED copy currently attached.

Ok. I think I got it for you - I had to change the file format to upload it (.xlsx is a compressed format) - it was too large as a .xls file


Here's what I did.

I Created a tab call "EMPLOYEE RESULTS CODED" - that list each employee once. Next to the Employee ID: you will see 13 columns of 1's or 0's - this tells you which courses the employee has passed. 1 = have completed this course, 0 = have not. After those columns you will see a bunch of "TRUE" & "FALSE" values for each location (for the next 83 columns).

That tells you if a given employee is compliant for a given location.



Back on your "No. of Comp Staff by Location" tab - you'll see the counts for each location (counts the "trues" from the other tab).

Please have a look, this one took some noodling