How to Calculate NPS: Formula, Examples, and Common Mistakes
Learn the Net Promoter Score formula step by step with real examples. Understand promoters, passives, and detractors, plus common calculation mistakes to avoid.
Net Promoter Score is one of the most widely used customer experience metrics in business. It distills customer loyalty down to a single number that ranges from -100 to +100. Despite its simplicity, many teams still make mistakes when calculating it. This guide walks through the NPS formula step by step, provides worked examples, and highlights the most common pitfalls to avoid.
The NPS Question and Scale
NPS is built on a single survey question:
"On a scale of 0 to 10, how likely are you to recommend our product/service to a friend or colleague?"
Respondents choose a whole number from 0 (not at all likely) to 10 (extremely likely). That is the entire quantitative portion of the survey. Most implementations also include an open-ended follow-up question such as "What is the primary reason for your score?" to capture qualitative context, but the score itself is what drives the NPS calculation.
Understanding the Three Groups
Based on their response, each customer falls into one of three categories.
Promoters (9-10)
Promoters are your most enthusiastic customers. They actively recommend your product, buy more over time, and contribute to organic growth through word of mouth. A score of 9 or 10 signals strong loyalty and satisfaction.
Passives (7-8)
Passives are satisfied but unenthusiastic. They are unlikely to spread negative word of mouth, but they are also unlikely to actively promote your brand. They are vulnerable to competitive offers and could switch if a better alternative comes along. In the NPS calculation, passives are counted in the total number of respondents but are not directly used in the formula.
Detractors (0-6)
Detractors are unhappy customers who may discourage others from using your product. They are at the highest risk of churning and can damage your brand through negative reviews and word of mouth. The range is deliberately wide (0 through 6) because NPS treats anything below genuine enthusiasm as a warning signal.
The NPS Formula
The formula itself is straightforward:
NPS = % Promoters - % Detractors
That is it. You calculate the percentage of respondents who are promoters, subtract the percentage who are detractors, and the result is your Net Promoter Score.
The result is expressed as a number (not a percentage), and it can range from -100 (every respondent is a detractor) to +100 (every respondent is a promoter).
Step-by-Step Calculation: Example 1
Suppose you survey 100 customers and receive the following responses:
- 45 respondents scored 9 or 10 (Promoters)
- 35 respondents scored 7 or 8 (Passives)
- 20 respondents scored 0 to 6 (Detractors)
% Promoters = (45 / 100) x 100 = 45%
Step 2: Calculate the percentage of Detractors.
% Detractors = (20 / 100) x 100 = 20%
Step 3: Apply the formula.
NPS = 45% - 20% = 25
Your NPS is 25. This is a positive score, which means you have more promoters than detractors. Generally, any score above 0 is considered acceptable, above 30 is good, and above 70 is excellent, though benchmarks vary significantly by industry.
Step-by-Step Calculation: Example 2
Now consider a smaller B2B company that surveys 60 customers after a product launch:
- 30 respondents scored 9 or 10 (Promoters)
- 12 respondents scored 7 or 8 (Passives)
- 18 respondents scored 0 to 6 (Detractors)
% Promoters = (30 / 60) x 100 = 50%
Step 2: Calculate the percentage of Detractors.
% Detractors = (18 / 60) x 100 = 30%
Step 3: Apply the formula.
NPS = 50% - 30% = 20
Despite having half of their customers as promoters, the relatively high proportion of detractors (30%) pulls the score down to 20. This is a clear signal that while the product resonates with many users, a significant segment is dissatisfied and needs attention.
Why Passives Are Excluded from the Formula
A common question is why passives do not appear in the final subtraction. The reasoning is intentional. Passives represent a neutral middle ground. They are not actively harming your brand, but they are not driving growth either.
By excluding them from the formula, NPS creates a sharper distinction between loyalty (promoters) and risk (detractors). However, passives still matter in two important ways:
- They affect the denominator. Because passives are included in the total respondent count, a large passive group dilutes the percentage of both promoters and detractors. If you converted passives into promoters, your NPS would increase significantly.
- They represent opportunity. Passives are the easiest group to move. They are already somewhat satisfied; small improvements in experience, support, or value can push them into the promoter category. Analyzing the open-ended feedback from passives often reveals quick wins.
Common NPS Calculation Mistakes
Mistake 1: Including Passives in the Subtraction
Some teams calculate NPS as % Promoters - % Passives - % Detractors, or try to weight passives in some way. This is incorrect. The formula is strictly % Promoters minus % Detractors. Passives only factor into the total respondent count used to calculate those percentages.
Mistake 2: Using Averages Instead of Percentages
Another frequent error is averaging all the scores (for example, adding up every response and dividing by the number of respondents). An average score of 7.2 on a 0-10 scale might sound reasonable, but it tells you nothing about the distribution. You could have a bimodal distribution with scores clustered at 2 and 10, producing the same average as a distribution clustered entirely around 7. NPS specifically avoids averages because the promoter-detractor split is what reveals loyalty dynamics.
Mistake 3: Working with Small Sample Sizes
NPS becomes unreliable with very small samples. If you survey 10 customers and 3 are detractors, that is 30% detractors, but a single additional response could swing your score by 10 points in either direction. As a general guideline, aim for at least 50 responses before treating your NPS as statistically meaningful. For segment-level analysis (by product, region, or customer tier), you need sufficient volume in each segment as well.
Mistake 4: Surveying at the Wrong Time
Timing affects NPS results more than most teams realize. Surveying immediately after a support interaction captures sentiment about that interaction, not about your product overall. Surveying during a product outage captures frustration that may not reflect long-term loyalty. Conversely, surveying only after positive milestones (such as a successful onboarding) will inflate your score. Be deliberate about when you send the survey and keep timing consistent across measurement periods.
Mistake 5: Ignoring the Follow-Up Question
NPS without qualitative context is a number without a story. The score tells you where you stand; the follow-up comments tell you why. Skipping the open-ended question, or collecting it but never analyzing it, means you are measuring without learning. The real value of NPS comes from understanding the themes behind the scores and acting on them.
How Often to Measure NPS
There are two main approaches to NPS measurement, and many organizations use both.
Relational NPS
Relational NPS measures overall loyalty to your brand or product. It is sent on a regular schedule, typically quarterly or biannually, to a broad sample of your customer base. The goal is to track trends over time and benchmark against industry standards.
Relational surveys should go out at consistent intervals and avoid overlapping with major product changes or incidents so that they reflect steady-state sentiment.
Transactional NPS
Transactional NPS is triggered by a specific event, such as completing a purchase, finishing onboarding, or closing a support ticket. It measures satisfaction with that particular experience rather than overall loyalty.
Transactional NPS is useful for identifying friction points in specific journeys and for closing the loop quickly with unhappy customers. The key is to avoid survey fatigue. Set rules to prevent the same customer from receiving multiple NPS surveys in a short period.
Finding the Right Cadence
Most teams benefit from running relational NPS on a quarterly basis and layering in transactional NPS at two or three key touchpoints. This provides both the big-picture trend and the granular, actionable detail.
Automate Your NPS Workflow
Calculating NPS manually with spreadsheets works when you have 50 responses. It becomes tedious at 500 and unsustainable at 5,000. Beyond the arithmetic, the real challenge is analyzing hundreds or thousands of open-ended comments to extract actionable themes.
FeedPulse calculates your NPS automatically as responses come in, segmenting scores by time period, customer attributes, and any custom dimensions you define. More importantly, FeedPulse uses AI to analyze the open-ended comments alongside each score, surfacing the key themes driving promoter enthusiasm and detractor frustration. Instead of reading through every comment manually, you get a clear picture of what to fix, what to keep, and what to double down on.
Key Takeaways
- NPS is based on one question rated on a 0-10 scale. Respondents are grouped into Promoters (9-10), Passives (7-8), and Detractors (0-6).
- The formula is simple: NPS = % Promoters - % Detractors. The result ranges from -100 to +100.
- Passives are excluded from the formula but included in the total respondent count. They represent your biggest conversion opportunity.
- Avoid common mistakes like including passives in the subtraction, using score averages, relying on small samples, or surveying at inconsistent times.
- Measure regularly using relational NPS for trends and transactional NPS for journey-specific insights. Quarterly relational surveys are a solid starting point.
- The score alone is not enough. Always pair it with the open-ended follow-up question and invest time in analyzing qualitative feedback.
- Automate where possible. Tools like FeedPulse handle the calculation, segmentation, and AI-powered comment analysis so your team can focus on taking action rather than crunching numbers.
Ready to start collecting feedback?
Set up NPS, CSAT, or CES surveys in under 2 minutes. Free plan available.
Get started free