I'm trying to calculate the values of entries in cells for associates, that
are grouped by supervisors, and then get the % of the values returned for
that supervisor's associate's results.

Each associate has 2 metrics that they are graded on. Values in the cells
are either Satisfactory or Non-Satisfactory.

Example: Supervisor A has 4 associates. 2 associates are Satisfactory in
both metrics, 1 is sat/non-sat, another is non-sat/sat. Manually calculating
the results, that supervisor would be 75% in the first metric, 75% in the
second.

Problem is that I have 300+ associates to track :[ Help?