Free calculator
Net Promoter Score (NPS) calculator
Enter how many people gave each type of answer on the usual 0–10 “likely to recommend” scale. This page computes % promoters (9–10) and % detractors (0–6), then NPS = % promoters − % detractors in the −100 to +100 range. It measures customer loyalty and recommendation intent—not India’s NPS (National Pension System), and not a full survey platform.
When to use this calculator
Tallying close-the-loop surveys and CX pulse data before you build the rest of a spreadsheet story.
- You already have a 0–10 NPS style column and you only need NPS = %9–10 − %0–6 with clean percent lines for a slide or memo.
- You exported per-score frequencies from a survey tool and want to match a three-bucket summary the team shares verbally.
- You are sanity-checking a number someone quoted from a dashboard (same rounding of % you see in many guides).
- For generic percent of a number or change between two values, use the percentage calculator from the tools hub; this page keeps only the NPS bucket and % − % line.
We use the standard 0–10 recommendation scale, three segments, and the usual % promoters − % detractors NPS form seen in NPS guides. Passives (7–8) sit in the middle—they change how big each % is because % = 100 × count ÷ n, but the NPS headline line does not add a separate “passive” leg.
Bucketing
Promoters: 9 and 10. Passives: 7 and 8. Detractors: 0 through 6.
NPS = % promoters − % detractors
With P, A, and D the three counts, % promoters = 100 × (P) ÷ (P+A+D), % detractors = 100 × (D) ÷ (P+A+D). We set NPS = round(% promoters) − round(% detractors), a common presentation choice when the two % lines are rounded to whole percents. Passives matter because they share the same total n in the % denominators, even though the NPS sentence only names promoter and detractor % in the subtraction.
Short example (same as many tutorials)
P = 80, A = 30, D = 40, so n = 150: % promoters = 100 × 80 ÷ 150 ≈ 53.3 → 53% rounded, % detractors = 100 × 40 ÷ 150 ≈ 26.7 → 27% rounded, NPS = 53 − 27 = 26 (integer).
Not in this tool’s scope
eNPS (employee) programs, 5-point or 0–5 custom scales, industry benchmark tables, statistical confidence, tNPS vs rNPS program design, or pension planning—if you need SIP/SWP-style compounding, use the dedicated finance calculators.
Not a substitute for a professional Voice of the Customer process—just fast transparent counts → NPS to match a spreadsheet row. For generic percent of a total from two numbers, see the percentage calculator.
Google Sheets & Excel
Assume a column of 0–10 raw scores, for example in A2:A1000. The cards below use EN function names; rename to DE/FR packs if you use localized functions.
=COUNTIFS(Range, ">=9")Replace Range with your 0–10 data range; counts 9 and 10 in one go.
=COUNTIF(Range, "<=6")COUNTIFS with <= 6 and >= 0 is equivalent; COUNTIF is the shortest for one column.
=ROUND(100*B1/B3,0)-ROUND(100*B2/B3,0)B1 = promoter count, B2 = detractor count, B3 = total n—keeps the same rounded-% shortcut as this page. Add 0 in B1/B2 if a bucket is empty.
Frequently asked questions
What is the Net Promoter Score formula?
On this page: first group 0–6 (detractors), 7–8 (passives), and 9–10 (promoters). % promoters = 100 × (promoter count) ÷ (total n). % detractors = 100 × (detractor count) ÷ (total n). NPS = round(% promoters) − round(% detractors). That matches the % lines many teams report before subtracting. NPS, Net Promoter, and Net Promoter Score are registered marks of Bain & Company, Inc., Satmetrix Systems, Inc., and Fred Reichheld; this is an educational view of your data.
How do “passive” (7–8) responses change NPS?
They are in the denominator when you turn counts into % of all answers, so a large passive share can move both % lines. The NPS headline is still % promoters − % detractors; passives are not a third add-on in that one-line subtraction the way promoters and detractors are.
Is NPS always 0 to 10?
The NPS standard people reference for % promoters − % detractors is the 0–10 “likely to recommend” item. If your survey used a different scale, do not plug counts into this page and expect a comparable industry NPS; recode to 0–10 first in your research script.
What is a “good” NPS number?
Context matters more than a single universal “good” score. Compare trends in your program and, when helpful, to credible industry or competitive benchmarks from research you trust—this page does not show live benchmark data.
Is this the same “NPS” as India’s National Pension System or other pension “NPS” search results?
No. In search, “NPS” is ambiguous: many results point to India’s National Pension System, not to Net Promoter Score for customer recommendation. This tool is for 0–10 loyalty / recommendation counts only.
How do I match this in Google Sheets or Excel?
Use the formulas below the calculator: count 9–10 in one go, count 0–6, and apply % to n. Localize COUNTIF / COUNTIFS names to your language pack. Keep the 0–10 data in one column to avoid off-by-one ranges.
Is this HR, market research, or product advice?
No. The page is a math and wording helper for 0–10 NPS counts you already have—not legal, HR, compliance, or professional survey advice.