It wasn’t a hard choice to select SmartSurvey. Not only did they understand what we were looking to achieve right from the start, they presented a solution that represented everything we needed.
How is NPS® Calculated?
How is NPS® Calculated?
Trying to work out the calculation to your Net Promoter Score® survey can seem a little daunting at first, but with the right explanation, tools and formulae, you’ll soon understand how to calculate this and get the answers you need.
Calculating your NPS
Your Net Promoter Score is calculated by working out the difference between the proportion of promoters and detractors, to generate a score of between -100 and 100.
How you calculate NPS will depend on the size of your data set, as there are number of approaches you can take:
A simple manual calculation:
You need to subtract the number of detractors from the number of promoters, which will leave you with a positive or negative number.
You then need to divide that answer by your total number of survey responses and multiply that by 100.
The number you get, rounded to the nearest whole number, should be between 100 and –100.
NPS excel formula:
For a larger data sets, which would be more time consuming to calculate manually you can work out your NPS with the following single spreadsheet formula:
=ROUNDUP((100*((COUNTIF([Data],">8")-COUNTIF([Data],">7"))/COUNT([Data]))),0)
Paste this into Excel or Google Sheets (or other spreadsheet), and just replace [Data] with the data range in your response spreadsheet that has the NPS answers in it.
Then simply run the formula and your score should appear right in front of you.
Net Promoter Score tool:
With more survey providers offering tools to work out your NPS, it’s becoming easier than ever to calculate.
If you’ve already captured your responses you can use our free NPS calculator to work out your score.
For customers on our Business plans and above we’ve built a tool into our Net Promoter Score question that will collect data that’s automatically processed to show you the correct score via our reporting tools.
More about NPS
- How to use the NPS question
- A Net Promoter Score example
- What is a good NPS score?
- The benefits of using NPS
Get started with NPS
To start capturing your Net Promoter Score, sign up to SmartSurvey or speak to our sales team.
NPS®, Net Promoter® & Net Promoter Score® are registered trademarks of Satmetrix Systems, Inc., Bain & Company and Fred Reichheld.
Smarter Survey Software
See why people use SmartSurvey to better engage respondents and reveal actionable insights.
Let’s fast track your success.
Request your demo!
Request your demo!
No Learning Curve, Just Expert Know-How.
Rapidly uncover the best ways to get things done, and explore the hidden superpowers in our platform.
Rapidly uncover the best ways to get things done, and explore the hidden superpowers in our platform.
How are we different?
We will help you collect the information you need quickly and easily. Trust us to safeguard your data and provide the support you need, when you need it.
UK based
Your data will be stored and processed here in the UK for your peace of mind.
Fanatical support
We pride ourselves on going above and beyond for our customers, providing expert advice and support whenever you need it.
You're in safe hands
Our secure platform and robust data protection measures ensure your data is safe and secure with us. We are ISO27001 and Cyber Essentials Plus certified.
We're human
We understand the importance of personal interaction, which is why we offer a human touch alongside our cutting-edge technology.
Accessibility matters
We're committed to making our surveys accessible to everyone, with a range of features to support those with disabilities.
Unlimited responses
With no limits on the number of responses you can collect, you can be sure your survey will reach as many people as possible without it being cost prohibitive.
You're in safe hands
Don’t just take our word for it
Trusted by leading companies and brands worldwide.
Over 500,000 users have registered to use SmartSurvey.
Over 500,000 users have registered to use SmartSurvey.
Farkhanda Maqbool, Policy Manager, GMC
We couldn't be happier with SmartSurvey, we love its functionality and flexibility. This means we have been able to use one survey tool across many parts of the business.
Martin, uSwitch
Multi-award winning survey software
Get in touch
We will help you collect the information you need quickly and easily. Trust us to safeguard your data and provide the support you need, when you need it.
UK-based and secure
We are ISO27001 certified, registered under the Data Protection Act and fully compliant with EU Privacy Laws.
Dedicated support
Access to a knowledgeable account manager for personal assistance for when you most need it.
Flexible to suit your needs
Our friendly design team is on hand to assist with any bespoke design and custom development requests.
We'll go that extra step
We succeed if you succeed. Our goal is to help you carry out effective research and we’re here to help you achieve that.
Get started and create your first survey
If you would like more information then please get in touch.
Elevate your survey game.
Discover the power of our cutting-edge survey software with a personalised demo!
SmartSurvey is a digital survey solution that helps anyone create surveys, build questionnaires and analyse the results.
