Excel guide · 5 min read
How to calculate candidate pass-through rate by interviewer in Excel
=COUNTIFS(B:B,F2,C:C,"Pass")/(COUNTIFS(B:B,F2,C:C,"Pass")+COUNTIFS(B:B,F2,C:C,"Fail")). Leave pending interviews out of the bottom of the fraction, and don't compare interviewers until each has enough decisions to mean something.Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E | F | G | H | I | J | K | L |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Candidate | Interviewer | Result | Hired | Interviewer | Decided | Passed | Pass rate | Passes closed | Passes hired | Hired / closed | |
| 2 | C-101 | Priya | Pass | Yes | Priya | 6 | 5 | 0.83333333333 | 4 | 2 | 0.5 | |
| 3 | C-102 | Marcus | Fail | Marcus | 4 | 1 | 0.25 | 1 | 1 | 1 | ||
| 4 | C-103 | Elena | Pass | No | Elena | 5 | 3 | 0.6 | 3 | 1 | 0.33333333333 | |
| 5 | C-104 | Priya | Pass | No | Tom | 1 | 1 | Too few | 0 | 0 | None closed | |
| 6 | C-105 | Marcus | Pass | Yes | All | 16 | 10 | 0.625 | 8 | 4 | 0.5 | |
| 7 | C-106 | Elena | Fail | |||||||||
| 8 | C-107 | Tom | Pass | Open | ||||||||
| 9 | C-108 | Priya | Fail | |||||||||
| 10 | C-109 | Marcus | Fail | |||||||||
| 11 | C-110 | Elena | Pass | Yes | ||||||||
| 12 | C-111 | Priya | Pass | Open | ||||||||
| 13 | C-112 | Marcus | Pending | |||||||||
| 14 | C-113 | Elena | Pass | No | ||||||||
| 15 | C-114 | Tom | Pending | |||||||||
| 16 | C-115 | Priya | Pass | Yes | ||||||||
| 17 | C-116 | Marcus | Fail | |||||||||
| 18 | C-117 | Priya | Pass | No | ||||||||
| 19 | C-118 | Elena | Fail |
Download this sheet as an Excel practice file (.xlsx)
The interview log
Recruiting funnel numbers tell you how many candidates move from one stage to the next. The interviewer view asks a narrower question: for the same stage, does one interviewer pass far more or far fewer people than the others? A big gap is a reason to talk about calibration (are they using the same bar and the same scorecard?), not proof that anyone is wrong.
The sample log has one row per candidate per interview: the candidate ID in A, the interviewer in B, the result in C (Pass, Fail or Pending) and, for candidates who passed, whether they were eventually hired in D (Yes, No, or Open while the process is still running). Fails leave D blank. If several people interview the same candidate, give each interviewer their own row, so every decision is counted once for the person who made it.
Keep names and results consistent. "Priya", "Priya " with a trailing space and "Priya S" are three different interviewers to COUNTIFS. A drop-down list from Data > Data Validation > List on columns B and C stops that before it starts.
Pass rate per interviewer with COUNTIFS
List each interviewer once in F (type them, or use =UNIQUE(B2:B19) in Excel 365). Count their decided interviews in G by adding passes and fails, count their passes in H, and divide.
Priya decided 6 interviews and passed 5, so her pass-through rate is 83%. Elena passed 3 of 5 (60%) and Marcus 1 of 4 (25%). Across everyone, 10 of 16 decided interviews were passes: 62.5%.
Result: 0.83333333333 shows as 83% with Percent format
83%: Priya passed 5 of the 6 candidates she decided on.
Keep pending results out of the denominator
The tempting shortcut is passes / all interviews: =COUNTIFS(B2:B19,"Marcus",C2:C19,"Pass")/COUNTIF(B2:B19,"Marcus"). That counts C-112, still Pending, as if Marcus had turned the candidate down, so his rate drops from 25% to 20%. Anyone who interviews a lot this week looks harsher than they are until their feedback is in.
Counting decided interviews as Pass + Fail fixes it. It's safer than COUNTIFS with "<>Pending", which would also count a row where the result hasn't been typed yet: a blank cell isn't "Pending", so it passes the "<>Pending" test and lands in the denominator.
Result: 0.2 shows as 20% with Percent format
20%, and it's wrong: because Marcus's pending interview is counted as a decision. The decided-only rate is 25%.
Set a minimum sample before you compare
Tom has decided one interview and passed it. A 100% pass rate from one candidate says nothing. Put a minimum number of decisions in an input cell (O1) and show "Too few" below it, so nobody ranks interviewers on noise.
The sample uses 4 so the example has something to show. In practice, use a much bigger number, often 15 to 20 decisions or more, and compare interviewers over the same period and for the same role. Interviewers who only see senior candidates, or only candidates from one source, will have different pass rates for reasons that have nothing to do with their judgment.
Result: Too few
Too few: Tom has 1 decided interview, below the minimum of 4 in O1.
Pass rate vs eventual hire
A high pass rate isn't a problem if the people passed go on to do well in later rounds. The second check is: of the candidates this interviewer passed, how many were hired? Count only passes whose outcome is known (D is Yes or No, not Open) in J, the hired ones in K, and divide.
Priya passed 5, 4 of those have a final outcome, and 2 were hired: 50%. Elena's passes were hired 1 time in 3 (33%). Marcus passed only one candidate, who was hired, so his 100% is another tiny sample. With real volumes, an interviewer with a high pass rate and a low hired-after-pass rate is passing people the next stage keeps rejecting, which is useful to raise in calibration.
Result: 0.5 shows as 50% with Percent format
50%: 2 of Priya's 4 closed passes were hired. Her fifth pass, C-111, is still Open and is left out.
Which version to use
For a quick look at one stage, the pass rate with the pending results left out is enough. Add the minimum sample as soon as you share the table with anyone, because a ranked list of percentages gets read as a scorecard. Add the hired-after-pass column when you want to know whether the bar is consistent across the whole process, not just at one step.
This is a calibration and process-health view. It doesn't say whether any hiring decision was right, and it shouldn't be used on its own to judge an interviewer. For the stage-by-stage view, see recruiting funnel conversion, and for the last step, the offer acceptance rate.
Common mistakes
Dividing by every interview, including pending ones
Use passes + fails as the denominator. Pending interviews haven't been decided yet.
Using "<>Pending" to count decisions
Blank results also pass that test. Count "Pass" and "Fail" explicitly, so a row with no result typed yet stays out.
Ranking interviewers on a handful of interviews
Set a minimum number of decisions in an input cell and show "Too few" below it. Compare like with like: same role, same stage, same period.
Names typed differently in different rows
Add a Data Validation drop-down for interviewers and results, and check the summary's total decided matches the log.
FAQ
What is a candidate pass-through rate?
It's the share of candidates who move on from a stage. By interviewer, it's the share of the candidates each interviewer decided on that they passed to the next step.
How do I count pass and fail by interviewer in Excel?
Use COUNTIFS with two conditions: the interviewer's name in the interviewer column and "Pass" (or "Fail") in the result column. Add the two counts to get the interviews they decided.
What is a good interviewer pass rate?
There's no universal number; it depends on the stage, the role and how well candidates are screened before they reach that interviewer. Compare each interviewer with the team's overall rate for the same stage, and only once they have enough decisions.
Should panel interviews count once or once per interviewer?
For a per-interviewer rate, give each panel member their own row with their own recommendation. For the stage's overall pass rate, count the candidate once with the panel's final decision.
Functions used
COUNTIFSCounts with several conditionsCOUNTIFCounts cells that matchIFPicks a result from a testUNIQUERemoves duplicates, spills
Related guides
- How to calculate recruiting funnel conversion rates in Excel
- How to calculate offer acceptance rate in Excel
- COUNTIF with multiple criteria in Excel (COUNTIFS)
- How to calculate time to hire in Excel
- How to build a source of hire report in Excel
- How to calculate backorder rate in Excel
- How to count colored cells in Excel
Updated