Cellwise Start free

Excel guide · 4 min read

How to calculate first contact resolution (FCR) in Excel

Quick answerFCR is tickets resolved on the first contact divided by tickets resolved. With a Status column and a Yes/No first-contact column: =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.

RowABCDEFGHIJKL
1TicketCustomerAgentReasonOpenedStatusAgent says FCRContacted againFCR (no repeat)Repeat window (days)7
2T-701Cust-114NadiaBillingOct 2, 2026ResolvedYesTRUENo
3T-702Cust-208OwenLoginOct 2, 2026ResolvedYesFALSEYes
4T-703Cust-114OwenBillingOct 5, 2026ResolvedYesFALSEYes
5T-704Cust-331NadiaShippingOct 6, 2026ResolvedNoFALSEYes
6T-705Cust-402RosaLoginOct 9, 2026ResolvedYesTRUENo
7T-706Cust-208RosaLoginOct 12, 2026ResolvedYesFALSEYes
8T-707Cust-517NadiaBillingOct 13, 2026OpenNoFALSE
9T-708Cust-402OwenLoginOct 14, 2026ResolvedYesFALSEYes
10T-709Cust-623RosaShippingOct 16, 2026ResolvedYesFALSEYes
11T-710Cust-331NadiaShippingOct 20, 2026ResolvedYesFALSEYes

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.

=COUNTIFS(F2:F11,"Resolved",G2:G11,"Yes")/COUNTIF(F2:F11,"Resolved")

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.

=COUNTIF(I2:I11,"Yes")/COUNTIF(F2:F11,"Resolved")

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.

=COUNTIF(I2:I11,"Yes")/COUNTA(A2:A11)

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.

=COUNTIFS(D2:D11,"Billing",I2:I11,"Yes")/COUNTIFS(D2:D11,"Billing",F2:F11,"Resolved")

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

Related guides

Updated