Averaging based on a condition

Hello all,   I am wanting to calculate a single average value based on a criterion in a range. I have a list of entities, the number of members associated with that entity, and a Y/N categorical fi...