Net Promoter Score (NPS) Calculator

This is a Net Promoter Score calculator for customer loyalty surveys (the 0–10 "how likely are you to recommend us" question), not a National Pension System calculator. Enter how many respondents were promoters, passives and detractors and you get your NPS, the percentage split, and the 95% confidence interval that shows whether a change is real or noise.

Free, no signup, and everything is calculated in your browser.

+45

NPS from 100 responses. Great.

Promoters60.0% (60)
Passives25.0% (25)
Detractors15.0% (15)
95% confidence interval30.5 to 59.5

How NPS is calculated

Respondents rate 0–10. Scores of 9–10 are promoters, 7–8 are passives, and 0–6 are detractors.

NPS = % promoters − % detractors, reported as a whole number from −100 to +100. It is not a percentage, so write it as 40, not 40%.

The mistake worth avoiding: passives are excluded from the numerator but stay in the denominator. Dropping them entirely inflates your score.

What is the Net Promoter Score?

The Net Promoter Score is a customer loyalty metric built on one question: "How likely is it that you would recommend [company] to a friend or colleague?", answered on a 0–10 scale. Fred Reichheld introduced it in the Harvard Business Review in 2003, and it was developed with Bain & Company and Satmetrix. Net Promoter, NPS and Net Promoter Score are registered trademarks of Bain & Company, NICE Systems and Fred Reichheld.

If you searched for an NPS calculator and wanted pension or retirement returns, this is the wrong page: that NPS is India's National Pension System, an unrelated government scheme. Everything below is about customer (and, with the same math, employee) Net Promoter Score.

Source: Reichheld, "The One Number You Need to Grow", Harvard Business Review (2003)

Source: Bain & Company: Measuring your Net Promoter Score

How to calculate NPS: the formula with a worked example

Sort every answer into one of three groups: promoters (9 or 10), passives (7 or 8) and detractors (0 to 6). Then: NPS = (promoters ÷ total responses × 100) − (detractors ÷ total responses × 100). The result is a whole number between −100 (everyone a detractor) and +100 (everyone a promoter).

Worked example (illustrative numbers): 200 customers answer. 110 give a 9 or 10, 50 give a 7 or 8, and 40 give 0–6. Promoters are 110 ÷ 200 = 55%. Detractors are 40 ÷ 200 = 20%. NPS = 55 − 20 = 35.

Notice the 50 passives. They are not in either percentage, but they are in the 200 you divide by. If you drop them and divide by 150 instead, you get 73.3% − 26.7% = 47, a 12-point inflation from a spreadsheet mistake. Enter the same three counts in the calculator above and it returns 35 with a 95% interval of 24.0 to 46.0.

Can you calculate NPS on a 5-point or 1–10 scale?

Not in a way anyone else can compare with. The promoter, passive and detractor bands are defined on the eleven-point 0–10 scale. Squeezing them onto five points (say, 5 = promoter, 4 = passive, 1–3 = detractor) produces a number with the same name and different behavior, and a 1–10 scale quietly removes the zero. If you already have five-point data, report it as a top-two-box satisfaction percentage instead (our CSAT calculator does that) and switch to 0–10 for the next wave.

NPS margin of error: how precise is your score?

An NPS is the difference of two proportions taken from the same sample, so its variance is not the familiar p(1 − p). Written with p as the promoter share and d as the detractor share (both as decimals), the variance of one response is p + d − (p − d)². The standard error of the NPS is the square root of that divided by n, times 100 to put it on the NPS scale. A 95% margin of error is 1.96 times the standard error.

In the worked example: p = 0.55 and d = 0.20, so the variance is 0.75 − 0.35² = 0.6275. Divide by 200 and take the square root: 0.056, or 5.6 NPS points. Times 1.96 gives a margin of error of about ±11. The honest way to report that survey is "NPS 35 (95% CI 24 to 46, n = 200)".

This is the interval the calculator shows. Brendan Rocks' 2016 paper in The American Statistician, which tested interval methods against 1,098 real NPS distributions from 236 companies, found this plain (Wald) interval covers the true score less often than it claims, especially at small samples. His best simple fix: add 0.75 to the promoter and detractor counts and 1.5 to the passive count, then run the same formula. For 15 promoters, 9 passives and 6 detractors (NPS 30), the plain interval is 2.1 to 57.9 and the adjusted one is 0.7 to 53.9. Above a few hundred responses the two barely differ.

Source: Rocks (2016), Interval Estimation for the 'Net Promoter Score', The American Statistician 70(4) — arXiv preprint

How many responses do you need for NPS?

95% margin of error in NPS points, from the variance formula above. The middle column assumes an illustrative split of 50% promoters, 30% passives and 20% detractors (NPS 30); the last column is the worst case, where every respondent is a promoter or a detractor in equal numbers.

Responses (n)Margin of error, 50/30/20 splitWorst-case margin of error
30±27.9±35.8
50±21.6±27.7
100±15.3±19.6
200±10.8±13.9
400±7.7±9.8
1,000±4.8±6.2

Margins shrink with the square root of n: to halve the margin you need four times the responses. Comparing two periods needs more still, because both scores carry error.

Sources: Rocks (2016), variance of the NPS, arXiv:1601.07235

Did our NPS really go up?

To compare two independent surveys, combine their standard errors: the margin of error on the change is 1.96 × √(SE₁² + SE₂²). Illustration: last quarter 100 promoters, 60 passives and 40 detractors (NPS 30, SE 5.5); this quarter 108, 60 and 32 (NPS 38, SE 5.3). The margin on the 8-point rise is about ±15, so the data are consistent with no change at all. Run each quarter through the calculator and look at whether the intervals overlap heavily; if they do, hold the celebration.

What is a good NPS? Benchmarks worth trusting

Most "average NPS by industry" tables online do not say who was surveyed, when, or how the question was asked, and NPS moves a lot with method: a survey sent right after a support ticket, a relationship survey to all customers, and a panel of consumers rating brands they have used will give different numbers for the same company. Treat any benchmark without a methodology note as decoration.

One that does publish its method is Qualtrics XM Institute's 2024 US consumer study: 10,000 consumers rating 354 companies across 22 industries, with each industry's score the average of its companies' scores. Industry averages ran from 15.8 (car rental) to 34.3 (grocery). Those are consumer-panel scores for B2C brands; your own survey of your own customers is a different measurement, and B2B relationships are not covered at all.

The labels the calculator prints (below zero, needs work, good, great, world class at 0, 10, 30 and 50) are rules of thumb, not a benchmark. The comparison that reliably means something is your score against your own previous score, collected the same way, with the margin of error beside both.

Source: Qualtrics XM Institute: 2024 XMI customer ratings — consumer NPS by industry

How to calculate NPS in Excel or Google Sheets

With raw 0–10 scores in B2:B201, these formulas work unchanged in both Excel and Google Sheets. COUNT ignores blank cells, so skipped answers do not count as zeros.

Scroll sideways to read all three columns.

CellFormulaWhat it returns
E1 — promoter share=COUNTIF(B2:B201,">=9")/COUNT(B2:B201)0.55 in the worked example
E2 — detractor share=COUNTIF(B2:B201,"<=6")/COUNT(B2:B201)0.20
E3 — responses=COUNT(B2:B201)200
E4 — NPS=ROUND((E1-E2)*100,0)35
E5 — 95% margin of error=1.96*SQRT((E1+E2-(E1-E2)^2)/E3)*10011.0
E6 — interval=E4-E5 and =E4+E524.0 to 46.0

Common spreadsheet errors: using COUNTA (counts text and headers), counting 7s and 8s as detractors, and formatting E4 as a percentage. NPS is a number, not a percent.

When NOT to use NPS

NPS summarizes intent to recommend. It is a poor fit when recommending makes no sense (a tax authority, a monopoly utility, an internal IT tool), when you need to judge a single interaction (use CSAT or CES right after it), or when the sample is too small for the margin of error to be useful. Keiningham and colleagues' 2007 study in the Journal of Marketing found NPS was no better than other satisfaction and loyalty measures at predicting company growth, which is a reason to treat it as one signal, not the scorecard.

Our comparison of NPS vs CSAT vs CES covers which metric to use at which moment.

Source: Keiningham et al. (2007), A Longitudinal Examination of Net Promoter and Firm Revenue Growth, Journal of Marketing

Common NPS calculation mistakes

Which follow-up questions should go with the NPS question?

The score tells you how many; the follow-up tells you why. The standard follow-up is open text: "What is the main reason for your score?" Asking it of everyone gives you comparable reasons across the three groups. If you branch, keep it short: detractors get "What would it take to raise your score by one point?", promoters get "What do you value most?", and passives get "What is missing?".

Two practical rules. Keep the survey to the NPS question plus one or two follow-ups; every extra question cuts responses and widens the margin of error you just read about. And tag the open-text answers into a handful of themes before the next wave, so you can see whether the reasons behind the score change, not only the score.

How to collect NPS data with a form

In Zunoform, the NPS question type renders the 0–10 scale, can ask a built-in follow-up ("What is the main reason for your score?" by default), and can drive logic on the score, so detractors can be sent to their own follow-up. The form's summary tab shows the promoter, passive and detractor split and the NPS for you; paste those counts into this calculator to get the interval. Publishing a form with an NPS question needs the Pro plan; you can build and preview it on Free.

Several templates already include an NPS question: the customer exit survey, patient satisfaction survey, post-event feedback, onboarding feedback and churn survey. If you run NPS in Google Forms instead, our guide to NPS surveys in Google Forms shows the linear-scale setup and the Sheets formulas.

Templates with an NPS question

Questions people ask

Is this an NPS calculator for the National Pension System?

No. This page calculates the Net Promoter Score, a customer loyalty metric from the question "How likely are you to recommend us?" on a 0–10 scale. India's National Pension System is an unrelated retirement scheme that shares the abbreviation; for pension returns you need a pension calculator from your bank or the scheme administrator.

What is a good NPS?

Above 0 means more promoters than detractors. Beyond that, benchmarks depend heavily on method: Qualtrics XM Institute's 2024 US consumer study put industry averages between 15.8 (car rental) and 34.3 (grocery). Your own previous score, collected the same way, is a better comparison than any published average, as long as you check the margin of error.

How many responses do I need for a reliable NPS?

More than most people collect. With an illustrative 50/30/20 split, 50 responses give a 95% margin of error of about ±22 points, 200 give about ±11, and 400 give about ±8. So a move from 30 to 40 on 50 responses tells you nothing. The calculator shows the interval so you can see when a change is real.

Do passives count in NPS?

They count toward the total but add nothing to the score. That is deliberate: a passive is someone who would not recommend you but would not warn people off either. Dropping passives from the denominator is the most common calculation error and always inflates the score.

Can you show a worked NPS calculation?

200 responses: 110 gave 9 or 10 (promoters), 50 gave 7 or 8 (passives), 40 gave 0–6 (detractors). Promoters are 55%, detractors are 20%, so NPS = 55 − 20 = 35. The margin of error is about ±11, so the 95% interval runs from 24 to 46.

Can NPS be negative?

Yes, down to −100. A negative score means more detractors than promoters, which is common for utilities, telecoms and anything people buy reluctantly. It is a signal, not a scandal; the trend over time, with its margin of error, matters more than the sign.

How do I calculate NPS in Excel?

With 0–10 scores in B2:B201: =(COUNTIF(B2:B201,">=9")-COUNTIF(B2:B201,"<=6"))/COUNT(B2:B201)*100. The same formula works in Google Sheets. Use COUNT rather than COUNTA so blanks and text are ignored, and keep passives in the denominator.

How do I calculate the NPS margin of error?

With p and d as the promoter and detractor shares in decimals and n as responses: margin = 1.96 × √((p + d − (p − d)²) ÷ n) × 100. For 55% promoters and 20% detractors out of 200, that is about ±11 points. For small samples, add 0.75 to promoters and detractors and 1.5 to passives first (Rocks, 2016).

Further reading

Related tools

Ready when you are

Better forms.
Better data.

Start with a conversation, a document or a single page.
Unlimited forms and 500 responses per month on Free.
No card required.

  • No credit card
  • Unlimited forms
  • 500 responses / month