NPS Calculation: Formula, Method and Free Calculator (Complete 2025 Guide)

NPS calculation is based on a simple yet powerful formula: NPS = percentage of Promoters minus percentage of Detractors. In practice, you classify your respondents according to their score from 0 to 10, then apply the subtraction between the percentage of customers rating 9-10 (promoters) and those rating 0-6 (detractors). Passives (scores 7-8) are not counted in the final formula.

The three essential steps to calculate your NPS are: first, collect responses to the single recommendation question on a scale of 0 to 10; second, automatically categorize your respondents into detractors, passives, and promoters based on their score; and third, calculate percentages and apply the subtraction formula to obtain a score between minus 100 and plus 100.

Since its creation by Bain & Company in 2003, the Net Promoter Score has established itself as the star indicator for measuring customer loyalty and predicting growth. Simple to calculate yet rich in insights, NPS enables businesses of all sizes to quickly assess their customer performance.

>> Tips for a successful NPS survey, click here

NPS Calculator

Use our interactive NPS calculator below to get your Net Promoter Score instantly. Simply enter the number of responses received for each rating.

How to Calculate Your NPS: Step-by-Step Method

1. The Basic Formula

The NPS calculation is based on a simple formula:

NPS = % of Promoters – % of Detractors

2. Identifying Respondent Categories

For accurate NPS calculation, it’s essential to understand each respondent category and their impact on the final score.

Detractors (0-6)

These dissatisfied customers represent a risk for your company:

• Scores from 0 to 2 indicate a very negative experience requiring immediate action
• Scores from 3 to 4 signal major problems in the customer experience
• Scores from 5 to 6 reveal moderate but significant dissatisfaction

Each detractor counts negatively in your NPS calculation, hence the importance of identifying them to implement corrective actions.

Passives (7-8)

Although not counted in the final NPS formula, these customers are strategic:

• A score of 7 indicates basic but fragile satisfaction
• A score of 8 shows adequate satisfaction but without enthusiasm
• These customers can easily shift toward becoming detractors or promoters

Promoters (9-10)

These highly satisfied customers are your best ambassadors:

• A score of 9 represents excellent satisfaction
• A score of 10 indicates maximum delight
• Each promoter counts positively in your NPS calculation

Category	Scores	Behavior	Impact on NPS Calculation	Priority Action
Detractors	0 to 6	Dissatisfied, risk of negative word-of-mouth	Counts negatively (-)	Immediate treatment of dissatisfaction causes
Passives	7 to 8	Satisfied but without enthusiasm, vulnerable to competition	Not counted (neutral)	Conversion to promoters through targeted actions
Promoters	9 to 10	Very satisfied, brand ambassadors	Counts positively (+)	Capitalize and implement loyalty programs

3. Concrete NPS Calculation Example

Let’s take a detailed practical case to understand the NPS calculation step by step.

Initial Situation

Imagine a company that has collected 250 responses distributed as follows:

Detractors (0-6)

• Scores 0-2: 15 responses
• Scores 3-4: 25 responses
• Scores 5-6: 45 responses

Total detractors: 85 responses

Passives (7-8)

• Score 7: 65 responses
• Score 8: 35 responses

Total passives: 100 responses

Promoters (9-10)

• Score 9: 40 responses
• Score 10: 25 responses

Total promoters: 65 responses

Detailed Calculation

1. Calculating the percentage of detractors

(85 ÷ 250) × 100 = 34%

2. Calculating the percentage of promoters

(65 ÷ 250) × 100 = 26%

3. Final NPS calculation

NPS = 26% - 34% = -8

Result Analysis

In this example:

• The negative score (-8) indicates a need for improvement
• The significant proportion of passives (40%) represents an opportunity for conversion to promoters
• The high number of 5-6 scores (45 responses) suggests customers close to becoming passives

Impact of Variations

To understand calculation sensitivity:

• If 10 detractors become passives: NPS rises to -4
• If 10 passives become promoters: NPS rises to -4
• If both changes occur simultaneously: NPS rises to 0

This detailed understanding of the calculation allows you to:

• Better target improvement actions
• Predict the impact of corrective actions
• Establish realistic NPS evolution objectives

Tips for Accurate NPS Calculation

Precision in Net Promoter Score calculation plays a crucial role in the reliability of your customer satisfaction data. While the formula seems simple, certain points deserve special attention to avoid interpretation errors.

The Passive Trap in Calculation

The most common error concerns the treatment of passive customers. These customers, who give a score of 7 or 8, often represent a significant portion of responses. However, their role in the final calculation is often misunderstood.

Contrary to common belief, passives should not be integrated into the final NPS formula. Their only function is to participate in calculating the total percentage of respondents. Including them in the final subtraction risks significantly underestimating your score.

For example: Out of 100 responses, if you have:

• 30 promoters (scores 9-10)
• 40 passives (scores 7-8)
• 30 detractors (scores 0-6)

The correct calculation will be: 30% – 30% = 0 And not: 30% – 70% = -40%

The Importance of Sample Size

The reliability of your NPS depends directly on the number of responses collected. A minimum of 100 responses is necessary to obtain a representative score. Below this threshold, a single response can have a disproportionate impact on your final score.

For finer analysis, particularly if you wish to segment your results by customer type or product, ideally aim for between 200 and 300 responses. This broader base will allow you to identify significant trends in each segment without risking hasty conclusions based on too small samples.

Rounding Management: A Detail That Counts

The treatment of decimals may seem trivial, but it directly impacts your score’s accuracy. Here’s the recommended method:

1. Keep all decimals in your intermediate calculations
2. Only round at the final calculation stage
3. Always round to the nearest whole number

When and How to Calculate Your NPS

The timing of your NPS calculation directly influences the relevance of the insights you’ll gain from it. There isn’t a single ideal moment, but rather different measurement opportunities, each providing specific insight into your performance.

Post-Purchase NPS Calculation: Capturing Emotion

Immediate measurement, conducted 24 to 48 hours after a transaction, allows you to capture customers’ fresh feedback. This is a crucial moment when the purchase experience is still fresh in their minds. Feedback collected at this stage is particularly valuable for:

• Identifying friction points in your purchase process
• Evaluating customer service performance
• Detecting delivery or first-use issues

A low score at this stage requires rapid action to prevent negative word-of-mouth spread.

The Cool-Down Measure: Evaluating Sustainable Satisfaction

A second measurement, conducted 2 to 4 weeks after purchase, offers a different but equally valuable perspective. At this stage, your customers have had time to:

• Fully use your product
• Explore its features
• Form an opinion based on experience rather than emotion

This measurement is particularly relevant for complex products or services requiring a learning period.

Regular Cycle: Tracking Trends

Beyond one-time measurements, implementing a regular NPS calculation cycle is essential for tracking customer satisfaction trends over time. It is recommended:

For B2B: Quarterly calculation allows tracking satisfaction evolution while giving corrective actions time to bear fruit.

For B2C: Semi-annual measurement offers a good compromise between reactivity and statistical relevance. It also helps avoid respondent fatigue.

2025 NPS Benchmark: Compare Yourself to Your Sector

To give meaning to your NPS score, it’s essential to compare it to the averages in your industry. Each industry has its specificities and standards, and a score considered excellent in one sector might be average in another.

Industry Sector	Average NPS Score 2025	Performance Level	Key Success Factors
E-commerce	45	⭐ Excellent	Digital customer experience, fast delivery
B2B SaaS	42	⭐ Excellent	Responsive customer support, product innovation
Hospitality	40	⭐ Excellent	Personalized service, quality hospitality
Insurance	35	🟡 Good	Digital transformation, process simplification
Financial Services	34	🟡 Good	Personalized advice, pricing transparency
Traditional Retail	30	🟡 Average	Omnichannel strategy, in-store experience
Transportation	28	🔴 Needs Improvement	Punctuality, incident management

High-Performing Sectors (NPS > 40)

• E-commerce (45): Overall sector leader, driven by mature players in customer experience and ease of offer comparison.
• B2B SaaS (42): Excellence driven by customer support and continuous innovation.
• Hospitality (40): Sector historically oriented toward customer satisfaction.

Intermediate Sectors (NPS 30-40)

• Insurance (35) and Financial Services (34): Sectors in digital transformation with growing attention to customer experience.
• Traditional Retail (30): Progressing through omnichannel and integration of customer feedback in continuous service improvement.

Lagging Sectors (NPS < 30)

• Transportation (28): Operational challenges impacting customer satisfaction, particularly in terms of punctuality and incident management.

These benchmarks allow you to position your performance and identify your improvement potential. Note that these averages mask significant disparities: sector leaders often exceed 50 NPS points, showing that excellence is possible regardless of your field.

💡 Expert Advice: Don’t just compare yourself to your sector’s average. Instead, aim for the performance of the top 25% of players in your industry to build a sustainable competitive advantage.

This sectoral positioning should serve as a basis for your continuous improvement strategy. Gaps with sector leaders can be explained by several factors:

• Company’s digital maturity
• Quality of team training
• Management’s commitment to customer culture
• Efficiency of customer feedback processing

To progress, focus on identifying best practices from sector leaders while considering your specificities. The goal isn’t to copy but to draw inspiration for building your own operational excellence.

Interpreting Your NPS Score: Beyond the Numbers

Net Promoter Score interpretation requires nuanced analysis that goes well beyond simply reading a number. This metric, ranging from -100 to +100, takes on its full meaning when contextualized and analyzed in depth.

Decoding Score Variations

A significant variation in your NPS always deserves thorough analysis. Here’s how to interpret these changes.

Sudden Drops

A sudden drop of more than 10 points should trigger immediate investigation. It may result from several factors:

• A recent change in your processes
• A modification of your offering
• An undetected technical issue
• An evolution in customer expectations

In this case, prioritize qualitative analysis of customer comments to quickly identify the source of the problem.

Progressive Improvements

A regular increase of 2 to 5 points per quarter typically demonstrates an effective continuous improvement strategy. This “healthy” progression indicates that:

• Your corrective actions are bearing fruit
• Your understanding of customer expectations is becoming more refined
• Your teams are embracing customer culture

Segment Analysis: Refining Understanding

Segmenting your NPS provides valuable insights for steering your improvement strategy. It’s important to consider customer tenure and sales channels.

Customer Tenure

Comparing NPS between new customers and historical customers reveals the quality of your onboarding process and the evolution of your value proposition. A significant gap might indicate:

• Problems in new customer integration
• A positive evolution of your offering
• A disconnect between marketing promise and reality

Sales Channels

Analyzing NPS by distribution channel helps identify best practices and weaknesses in each circuit. For example, a higher NPS on your e-commerce site than in your physical stores might suggest:

• A need for in-store team training
• Better digital experience ergonomics
• Different customer expectations depending on the channel

Actions to Implement Based on NPS Score

For a Negative Score (< 0)

The priority is to identify and address major sources of dissatisfaction. Focus on:

1. Detailed analysis of detractor comments
2. Implementation of urgent corrective action plan
3. Close monitoring of satisfaction indicators

For an Average Score (0-30)

The goal is to progressively optimize customer experience:

1. Identify your strengths to capitalize on them
2. Work on converting passives to promoters
3. Implement tracking indicators for each touchpoint

For a High Score (> 30)

Maintain your excellence while innovating:

1. Document your best practices
2. Test innovations to positively surprise your customers
3. Mobilize your promoters as ambassadors

Mastering NPS Calculation to Drive Your Growth

Net Promoter Score calculation is based on a simple formula that unfolds in three practical steps: collecting responses, automatically categorizing respondents, and applying the subtraction between promoters and detractors. This methodological simplicity should not overshadow the wealth of insights you can derive from it to guide your customer strategy.

Your next step depends directly on your current situation. If you’re new to NPS, focus on establishing a regular collection process with a minimum of 100 responses per cycle to ensure statistical reliability of your data. If you’re already measuring your NPS, move on to segmented analysis by customer type or sales channel to identify your priority improvement levers. If your score is negative or stagnant, immediately invest in qualitative analysis of detractor comments and establish a corrective action plan with measurable quarterly objectives.

NPS is not an end in itself but a diagnostic tool that gains its full value when integrated into a continuous customer experience improvement approach.

FAQ: Your Questions About NPS Calculation

How to Easily Calculate Your NPS with Excel or Google Sheets?

To calculate your NPS with a spreadsheet, start by organizing your data in a column with all the scores from 0 to 10 that you’ve collected. Then use the COUNTIF function to automatically count the number of responses per category: for promoters, count scores 9 and 10; for detractors, count scores from 0 to 6; and calculate the total responses with the COUNT function. Divide each category by the total to get percentages, then subtract the detractor percentage from the promoter percentage. The final formula in Excel will look like: (COUNTIF(range;”>=9″)/COUNT(range) – COUNTIF(range;”<=6″)/COUNT(range)) multiplied by 100. This method allows you to automate the calculation and easily update it with each new collected response.

What’s the Difference Between NPS Calculation in B2B and B2C?

The NPS calculation formula remains identical in B2B and B2C, but the application methods differ significantly depending on the business context. In B2B, you generally work with a smaller volume of respondents because your customer base is more limited, which means a minimum of 50 to 100 responses may suffice to obtain usable data. Measurement frequency is also different, with quarterly or semi-annual surveys that better match long decision cycles. In B2C, the data volume is much larger, allowing for more robust statistical analyses and fine segmentation by customer profile. Measurement can be monthly or even weekly for high-traffic businesses. Interpretation also varies: in B2B, losing a detractor can have a major business impact, while in B2C the analysis focuses more on overall trends and behavior patterns.

Can You Have a Negative NPS and What to Do in That Case?

Yes, NPS can absolutely be negative, with a score potentially dropping to minus 100 in the worst case, which simply means you have more detractors than promoters in your customer base. A negative score is not a death sentence and is frequently encountered in certain sectors like transportation or telecommunications where average benchmarks hover around 20 to 30. If you find yourself with a negative NPS, the absolute priority is to analyze in depth your detractors’ comments to identify recurring problems and major friction points in your customer journey. Implement an immediate corrective action plan on the three main identified sources of dissatisfaction, and contact your detractors individually to understand their experience and demonstrate your commitment to fixing the problems. Measure the impact of your actions with close monthly NPS tracking to verify that improvements are bearing fruit.

How Long Does It Take to See NPS Improvement After Corrective Actions?

The timeframe for observing measurable improvement in your NPS depends directly on the nature of corrective actions implemented and the frequency of your surveys. For technical fixes or simple process modifications like improving customer support response time or simplifying a purchase journey step, you can see results in 1 to 3 months with a 5 to 10 point increase. For deeper transformations involving cultural or organizational change, like complete customer experience redesign or team training, count on 6 to 12 months before seeing a significant impact of 15 to 20 points. The key is to maintain regular measurement to track progress, establish realistic intermediate objectives rather than aiming for immediate radical transformation, and communicate progress to your teams to maintain motivation. A consistent gain of 2 to 3 points per quarter indicates a healthy and sustainable continuous improvement dynamic.

How to Calculate NPS Simply?

NPS calculation involves three simple steps:

1. Calculate the percentage of Promoters (scores 9-10)
2. Calculate the percentage of Detractors (scores 0-6)
3. Subtract the percentage of Detractors from the percentage of Promoters

The formula is: NPS = % Promoters – % Detractors. For example, with 40% Promoters and 20% Detractors, your NPS will be 20.

What’s the Ideal Frequency for Calculating NPS?

Calculation frequency depends on your industry:

• For B2B: Quarterly calculation recommended
• For B2C: Monthly or bi-monthly calculation advised
• After each important customer interaction: Immediate calculation

The key is maintaining regularity in your measurements to track evolution.

How to Know if an NPS Score is Good?

NPS scores vary by industry:

• E-commerce: a good score is > 45
• Financial services: a good score is > 34
• Traditional retail: a good score is > 30

Generally, any positive score is encouraging, and above 50 is considered excellent.

Are Passives Counted in NPS Calculation?

No, passives (scores 7-8) are not directly counted in the NPS formula. They only serve to calculate the total number of respondents to obtain percentages. Including them in the final calculation is a common mistake.

How Many Responses are Needed for a Reliable NPS?

To obtain a statistically reliable NPS, you need:

• Minimum: 100 responses
• Ideal: 200-300 responses
• For fine segmentation: > 300 responses

Too small a sample can give unrepresentative results.

How to Improve a Negative NPS?

To improve a negative NPS:

1. Analyze detractor comments in detail
2. Identify main friction points
3. Implement a corrective action plan
4. Closely monitor improvements
5. Contact detractors after corrections

Can NPS be Calculated by Customer Segment?

Yes, it’s actually recommended to segment your NPS by:

• Customer tenure
• Sales channels
• Product categories
• Geographic areas

This segmentation enables more targeted corrective actions.

What’s the Difference Between NPS and CSAT?

NPS measures loyalty and likelihood to recommend, while CSAT (Customer Satisfaction Score) measures immediate satisfaction. NPS is more predictive of long-term growth, while CSAT is more useful for evaluating specific interactions.

How to Leverage Customer Comments in NPS Calculation?

Comments should be:

• Systematically collected with the score
• Analyzed by problem categories
• Used to contextualize the score
• Transformed into concrete improvement actions

They are essential for understanding the reasons behind the score.

What Tools are Needed to Calculate NPS?

Several options are available:

• Excel/Google Sheets (for small volumes)
• Specialized tools like Drag’n Survey, SurveyMonkey, or Typeform
• CRM solutions integrating NPS
• Dedicated customer experience platforms

The choice depends on your data volume and analysis needs.

How to Integrate NPS Calculation into Customer Strategy?

NPS should be:

1. Integrated into main company KPIs
2. Regularly monitored in management meetings
3. Linked to team objectives
4. Used to guide improvement decisions
5. Regularly communicated to teams

Is NPS Calculation Different for B2B and B2C?

The formula remains the same, but specificities change:

• B2B: Focus on long-term relationships, less frequent measurement
• B2C: More frequent measurement, higher response volume

Benchmarks and interpretations vary by sector.

More about surveys:
Test a Google Forms alternative, click here
Exploring Top Online Survey Tools, click here
Compare Drag’n Survey and Survio, click here
Survey Creation Apps for Your Needs, click here
Discover software for creating quizzes, click here
The most popular online survey solutions, click here
The features of Drag’n Survey and Typeform, click here
Create an online survey with a multilingual tool, click here
How to effectively measure customer satisfaction, click here
Drag’n Survey, the multilingual online poll software, click here
The differences between Drag’n Survey and SurveyMonkey, click here

Read the article:
Polish – kalkulator NPS, click here
German – NPS-Rechner, click here
French – Calculateur Net Promoter Score , click here
Portuguese – Calculadora Net Promoter Score, click here