Excel guide · 4 min read
How to calculate first contact resolution (FCR) in Excel
=COUNTIFS(F2:F11,"Resolved",G2:G11,"Yes")/COUNTIF(F2:F11,"Resolved"). A stricter version counts a ticket as first-contact only if the same customer didn't contact you again within N days, checked with COUNTIFS on customer and a date window.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 | Ticket | Customer | Agent | Reason | Opened | Status | Agent says FCR | Contacted again | FCR (no repeat) | Repeat window (days) | 7 | |
| 2 | T-701 | Cust-114 | Nadia | Billing | Oct 2, 2026 | Resolved | Yes | TRUE | No | |||
| 3 | T-702 | Cust-208 | Owen | Login | Oct 2, 2026 | Resolved | Yes | FALSE | Yes | |||
| 4 | T-703 | Cust-114 | Owen | Billing | Oct 5, 2026 | Resolved | Yes | FALSE | Yes | |||
| 5 | T-704 | Cust-331 | Nadia | Shipping | Oct 6, 2026 | Resolved | No | FALSE | Yes | |||
| 6 | T-705 | Cust-402 | Rosa | Login | Oct 9, 2026 | Resolved | Yes | TRUE | No | |||
| 7 | T-706 | Cust-208 | Rosa | Login | Oct 12, 2026 | Resolved | Yes | FALSE | Yes | |||
| 8 | T-707 | Cust-517 | Nadia | Billing | Oct 13, 2026 | Open | No | FALSE | ||||
| 9 | T-708 | Cust-402 | Owen | Login | Oct 14, 2026 | Resolved | Yes | FALSE | Yes | |||
| 10 | T-709 | Cust-623 | Rosa | Shipping | Oct 16, 2026 | Resolved | Yes | FALSE | Yes | |||
| 11 | T-710 | Cust-331 | Nadia | Shipping | Oct 20, 2026 | Resolved | Yes | FALSE | Yes |
Download this sheet as an Excel practice file (.xlsx)
Method 1: the agent's resolved-first-time flag
Many helpdesk tools let the agent tick "resolved on first contact" when closing a ticket. If your export has that column, FCR is a simple count: tickets resolved with the flag set, divided by all resolved tickets.
In the sample, 9 of the 10 tickets are resolved (T-707 is still open) and agents marked 8 of those 9 as first-contact. It's quick, but it measures what the agent believes, and agents rarely know whether the customer had to come back.
Result: 0.88888888889 shows as 88.9% with Percent format
0.889: by the agents' own flags, FCR is 88.9%.
Method 2: no repeat contact within N days
The customer's view is stricter: the issue was solved first time if they didn't have to get in touch again. Put the window in an input cell (L1 = 7 days) and check each ticket in H2: =COUNTIFS($B$2:$B$11,B2,$E$2:$E$11,">"&E2,$E$2:$E$11,"<="&E2+$L$1)>0. It counts later tickets from the same customer opened within 7 days and returns TRUE if there's at least one.
Then I2 turns that into an FCR result for resolved tickets only: =IF(F2<>"Resolved","",IF(H2,"No","Yes")). FCR is the Yes count over resolved tickets.
Two tickets the agents marked Yes fail this test: Cust-114 came back three days after T-701, and Cust-402 came back five days after T-705. The opposite happens too: T-704 was flagged No, but the customer didn't contact you again within the window, so it counts as solved first time.
Result: 0.77777777778 shows as 77.8% with Percent format
0.778: measured by repeat contacts, FCR is 77.8%, eleven points lower than the agents' flags.
The window and the denominator change the number
Change L1 from 7 to 14 and FCR drops to 55.6%: Cust-208 came back after 10 days and Cust-331 after 14. There's no single right window. Pick one that fits how quickly your customers would notice the problem again, write it next to the metric, and keep it fixed so months are comparable.
The denominator matters as much. Dividing by resolved tickets (9) gives 77.8%. Dividing by all tickets (10), so an open ticket counts as a failure, gives =COUNTIF(I2:I11,"Yes")/COUNTA(A2:A11) = 70%. Excluding open tickets is the usual choice, but a backlog of open tickets can then make FCR look better than service really is, so report the open count beside it.
Also wait for the window to pass before you report. A ticket opened on the last day of the month can't be judged until N days later; report October's FCR in the second week of November.
Result: 0.7 shows as 70.0% with Percent format
0.7: with the open ticket counted as a failure, FCR is 70%.
FCR per agent and per reason
Add the agent to both COUNTIFS: =COUNTIFS(C2:C11,"Nadia",I2:I11,"Yes")/COUNTIFS(C2:C11,"Nadia",F2:F11,"Resolved"). Nadia and Rosa are at 66.7% (2 of 3 resolved), Owen at 100%. With samples this small, one ticket swings an agent by 30 points, so look at several weeks before drawing conclusions.
By reason is often more useful than by agent: billing questions resolve first time 50% of the time, login problems 75%, shipping 100%. A low FCR on one reason usually points to a process or knowledge-base gap rather than one person.
Note that Owen's T-703 and T-708 were themselves repeat contacts. They count as first-contact resolutions because the customer didn't come back after them. If you'd rather treat a repeat contact as a continuation of the original ticket, filter those rows out before counting.
Result: 0.5 shows as 50% with Percent format
0.5: only half of resolved billing tickets were solved first time.
Common mistakes
Trusting the agent flag alone
Check repeat contacts from the same customer within a window; the sample drops from 88.9% to 77.8%.
Missing same-day repeats
">"&E2 on dates alone ignores a second contact later the same day. Use date-time stamps if your export has them.
Reporting before the window has passed
Tickets from the last N days of the period can't be judged yet; wait N days after month end.
Mixing denominators between months
Decide whether open tickets count and keep the choice fixed, with the open count reported beside FCR.
FAQ
What is the formula for first contact resolution?
FCR = tickets resolved on the first contact / total tickets resolved. In Excel: =COUNTIFS(F2:F11,"Resolved",G2:G11,"Yes")/COUNTIF(F2:F11,"Resolved"), where G is the first-contact flag. Excel for call centers puts FCR beside AHT, service level and CSAT, with practice exercises.
How do I find repeat contacts in Excel?
For each ticket, count later tickets from the same customer within N days: =COUNTIFS(B:B,B2,E:E,">"&E2,E:E,"<="&E2+7)>0 returns TRUE when the customer came back within 7 days.
Should unresolved tickets count in FCR?
Usually FCR divides by resolved tickets only. Counting open tickets as failures gives a lower, stricter number. Either works if you state it and keep it the same every month.
How is FCR different from average handle time?
AHT measures how long each contact takes; FCR measures whether it solved the problem. Pushing AHT down by rushing customers usually pushes FCR down too, so track them side by side.
Functions used
COUNTIFSCounts with several conditionsCOUNTIFCounts cells that matchCOUNTACounts non-empty cellsIFPicks a result from a testDATEBuilds a date
Related guides
- How to calculate ticket reopen rate in Excel
- KPI formulas in Excel: how to calculate and score KPIs
- How to calculate average handle time (AHT) in Excel
- How to calculate SLA compliance in Excel
- How to calculate call abandonment rate in Excel
- How to add a checkbox in Excel (insert tick boxes)
Updated