You're right! I'm so sorry! That last range should be O not N... there is not
a single "Y" in the N column.

The Absolute references: The first column refers to the course and I want to
auto complete/copy the formula across to all the other courses (Q,R,S,T,
etc.), but the other two criteria(Checked out? and Contracted Employee?) need
be absolute to those specific columns.

Thank you so much. You have been a great help with this project!