How is NPS® Calculated?

Get Student Discount
Apply for Discount

How is NPS® Calculated?

Screenshot of our NPS calculator tool

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

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.

More survey design advice

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.

Icon of a hand holding a heart
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.
Quotation icon

Thanks to SmartSurvey, our communication strategy is making us stand out from the crowd. By using SMS, asking the right questions and acting on results, IKEA is one step ahead of the competition.

Alastair, IKEA
Quotation icon

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
Awards certificatesAwards certificates

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.

Find out how we can help

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!