I have a spreadsheet setup as a table, I need a formula that will lookup what name is in column f and compare that to a value "pass" or "fail" in column e and then output the total number of entries that meet the criteria. See below:

excel.png

Thanks in advance