Free NPS calculator
Work out your Net Promoter Score in seconds, from your totals or your 0 to 10 scores.
Free, with no sign-up. Your numbers stay in your browser.
How to use the NPS calculator
This NPS score calculator works from totals or from every answer:
- Choose how to add your answers. Pick Totals if you know how many promoters, passives and detractors you have. Pick Scores to paste every 0 to 10 answer, such as a column from a spreadsheet.
- Enter your numbers. Your score updates as you type.
- Check the working. The sum behind your score appears under it, so you can repeat it anywhere.
How do I calculate NPS?
To calculate your NPS score, subtract the percentage of detractors from the percentage of promoters. Promoters answer 9 or 10 to "How likely are you to recommend us to a friend or colleague?", and detractors answer 0 to 6. Passives, who answer 7 or 8, count towards the total only.
The NPS formula is:
NPS = % promoters − % detractors
For example, if 100 people answer and 58 are promoters, 26 are passives and 16 are detractors, your NPS is 58 − 16 = 42. NPS is reported as a whole number from −100 to 100.
Promoters, passives and detractors
- Promoters (9 and 10): loyal customers who are likely to recommend you.
- Passives (7 and 8): satisfied, but unlikely to tell others about you.
- Detractors (0 to 6): unhappy customers who may put others off.
What is a good NPS score?
Any score above 0 means you have more promoters than detractors. Many teams see 30 or more as good and 50 or more as excellent. Scores vary a lot by industry, so compare each new score with your own past results first.
| NPS | What it means |
|---|---|
| Below 0 | More detractors than promoters |
| 0 | As many promoters as detractors |
| 1 to 29 | More promoters than detractors |
| 30 to 49 | Good |
| 50 and above | Excellent |
How to calculate NPS in Excel or Google Sheets
Put one score per row in column A, then paste this formula into any other cell:
=ROUND((COUNTIF(A:A,">=9")-COUNTIF(A:A,"<=6"))/COUNT(A:A)*100,0)It counts your promoters and detractors, divides the difference by the number of scores and rounds the result to a whole number. A heading in the first row is fine, because the formula only counts numbers.
Looking for the Delighted NPS calculator?
Delighted, the survey tool from Qualtrics, closed on June 30, 2026. This calculator uses the same standard NPS formula, so the scores you worked out there compare directly with the ones you work out here.
Moving your survey as well? The NPS survey guide covers which questions to ask and when to send them.
Frequently asked questions
What is the NPS question?
The standard question is "How likely are you to recommend us to a friend or colleague?", answered on a scale from 0 to 10. Most surveys follow it with an open question about the reason for the score.
Can an NPS score be negative?
Yes. NPS runs from −100 to 100, and a negative score means you have more detractors than promoters. For example, 20% promoters and 45% detractors gives an NPS of −25.
Do passives count in NPS?
Passives count towards the total number of responses, but not as promoters or detractors. The more passives you have, the closer your score gets to 0.
Is NPS a percentage?
No. NPS is worked out from two percentages, but the result is a score from −100 to 100. Write it as 42, not 42%.
How many responses do I need for a reliable NPS?
There is no fixed minimum. With only a few responses, one answer can move your score a lot, so watch how it changes as more responses come in.
Can I use this calculator for employee NPS (eNPS)?
Yes. Employee Net Promoter Score (eNPS) uses the same 0 to 10 scale and the same formula. Ask "How likely are you to recommend us as a place to work?" and enter the answers here.
Is my data saved?
No. The calculator runs in your browser, and the numbers you enter are not sent anywhere or saved.