Cellwise Start free

Excel guide · 5 min read

How to calculate candidate pass-through rate by interviewer in Excel

Quick answerPass-through rate = candidates an interviewer passed / candidates they decided on (passes + fails). With interviewers in B, results in C and the name in F2: =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.

RowABCDEFGHIJKL
1CandidateInterviewerResultHiredInterviewerDecidedPassedPass ratePasses closedPasses hiredHired / closed
2C-101PriyaPassYesPriya650.83333333333420.5
3C-102MarcusFailMarcus410.25111
4C-103ElenaPassNoElena530.6310.33333333333
5C-104PriyaPassNoTom11Too few00None closed
6C-105MarcusPassYesAll16100.625840.5
7C-106ElenaFail
8C-107TomPassOpen
9C-108PriyaFail
10C-109MarcusFail
11C-110ElenaPassYes
12C-111PriyaPassOpen
13C-112MarcusPending
14C-113ElenaPassNo
15C-114TomPending
16C-115PriyaPassYes
17C-116MarcusFail
18C-117PriyaPassNo
19C-118ElenaFail

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%.

=COUNTIFS(B2:B19,"Priya",C2:C19,"Pass")/(COUNTIFS(B2:B19,"Priya",C2:C19,"Pass")+COUNTIFS(B2:B19,"Priya",C2:C19,"Fail"))

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.

=COUNTIFS(B2:B19,"Marcus",C2:C19,"Pass")/COUNTIF(B2:B19,"Marcus")

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.

=IF(G5<$O$1,"Too few",H5/G5)

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.

=IF(J2=0,"None closed",K2/J2)

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

Related guides

Updated