How to calculate NPS from response counts

Net Promoter Score is the percentage of promoters minus the percentage of detractors. Count ratings of 9–10 as promoters, 7–8 as passives, and 0–6 as detractors. Include passives in the total. This follows Bain’s NPS scoring method.

Example: 100 valid survey responses
GroupCountShare
Promoters (9–10)6060%
Passives (7–8)2525%
Detractors (0–6)1515%

NPS = 60 − 15 = 45. Report “NPS 45 from 100 responses,” rather than “45%” or the average of the ratings.

Already have totals in a spreadsheet?

If A2 contains promoters, B2 passives, and C2 detractors, use this formula with nonnegative whole-number counts. It leaves the result blank when there are no responses:

=IF(SUM(A2:C2)=0,"",100*(A2-C2)/SUM(A2:C2))

For individual ratings in a Google Sheet, use the Google Forms NPS guide. Do not combine surveys that use different questions, audiences, or collection periods.

Turn an NPS score into a useful next step

Enter the number of responses at each rating, from 0 to 10. Promoters are 9–10, passives 7–8, and detractors 0–6. The calculator totals the groups and subtracts the detractor percentage from the promoter percentage.

Keep relationship surveys, sent at a consistent interval, separate from surveys about a particular transaction. A recommendation question after a support ticket can reflect a different experience from a periodic relationship survey.

  • Read the reasons behind low and high ratings before deciding what to change.
  • Group recurring feedback into themes and assign someone to follow up where respondents have agreed to contact.
  • Compare the same audience and question over time, and report the response count alongside the score.

Need to collect NPS responses first?

This calculator works with response counts you already have. To ask customers for a rating and understand the reason behind it, start with the free NPS survey template.

  1. Keep the 0–10 recommendation question and add a short reason question.
  2. Choose the customer audience, collection period, and invitation channel.
  3. Assign someone to review the answers and follow up where the customer has agreed to contact.

Youform collects the survey responses. Configure recurring invitations and any CRM handoff in your chosen workflow; this local calculator does not send surveys or automatically sync their results. For feedback about a particular interaction, explore customer satisfaction surveys.