Hi all - I’m trying to create a formula that will determine the pass/fail percentages for individual students. I know I can use the COUNTIF and COUNTA functions, but how can I create a formula that will take only calculate the pass/fail percentage for Jeremy? (See below)

Table 1 - Jeremy - John - David - Jeremy
Table 2 - Pass - Fail - Pass - Fail

I know it would be something like If Table 1 = “Jeremy”, Then COUNTIF/COUNTA, but I’m struggling with actually coming up with the formula.