<iframe src="//www.googletagmanager.com/ns.html?id=GTM-KC3JWW" height="0" width="0" style="display:none;visibility:hidden">

Blog

    Filter by month
    Filter by Category

    How to Calculate Net Promoter Score

    Business colleagues calculate Net Promoter Score

    Calculating the score from an NPS survey can seem daunting at first, but in this blog, we’ll explain a little of the methodology behind the score, and show you an excel formula for calculating it.

    The Three Groups.

    Net promoter scores are based by grouping respondents into three groups, based on their answer to the question “How likely is it that you would recommend [this company] to a friend or a colleague”, on a scale of one to ten.

    People who answer between one and six are “detractors”, seven and eight are “neutral” and those who answer nine or ten are “promoters”.

    The Calculation

    Firstly, the total numbers of promoters and detractors need to be identified.

    With those numbers determined, you subtract the number of detractors from the number of promoters. It’s fine if this number is positive or negative.

    Divide the answer to that by the total number of responses, then multiply it by 100.

    The number you get, rounded to the nearest whole number, should be between 100 and -100. If it isn’t, you’ve gone wrong somewhere and need to do the calculation again. If it is, then this is your score.

    NPS Excel Formula

    If you’ve got a large data set, then doing things manually via the above method can be time-consuming, but it can be done with a single spreadsheet formula.

    Here it is:

    =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.

    Run the formula and there you are. Your score should be right there looking at you from the spreadsheet cell.

    But here’s the best part – SmartSurvey makes even this method unnecessary. Our built-in Net Promoter Score question will collect data that’s automatically processed to show you the correct score via our reporting tools.

    All you need to do is create a survey, add the question, and choose what you want to ask about, it couldn't be easier.

    NPS®, Net Promoter® & Net Promoter® Score are registered trademarks of Satmetrix Systems, Inc., Bain & Company and Fred Reichheld.

    Matter of Focus Choose SmartSurvey
    Measuring Your Net Promoter Score

    About Author

    Default Author Image
    Rich Tysoe

    Richard is a product specialist at SmartSurvey, he helps with product development and technical solutions.

    Related Posts
    5 Customer Questions That Can Deliver Real Value For Your Business
    5 Customer Questions That Can Deliver Real Value For Your Business
    Improving Customer Experience With Surveys And Customer Feedback Loops
    Improving Customer Experience With Surveys And Customer Feedback Loops
    10 Compelling Reasons Why You Should Survey Your Customers
    10 Compelling Reasons Why You Should Survey Your Customers

    Comment

    Subscribe To Blog

    Subscribe to Email Updates