Measure experience

How to calculate NPS in Excel

You leave with the exact formulas, a short step-by-step, and a free workbook with the calculation built and explained.

Free · no sign-up Estimated time: 5 minutes This calculation runs on your device. We do not save your inputs.
Direct answer

How do I calculate NPS in Excel?

With the 0–10 scores in one column, count each group with COUNTIF: promoters =COUNTIF(A2:A200,">=9"), detractors =COUNTIF(A2:A200,"<=6"), and the total with COUNTA. NPS is (promoters − detractors) ÷ total × 100, a number from −100 to +100 that takes no percent sign. The free NPSLab workbook ships this calculation ready-made, with input validation and automatic interpretation of the result.

Step by step in Excel

1) Paste the scores into column A. 2) In B1: =COUNTIF(A:A,">=9"). 3) In B2: =COUNTIF(A:A,"<=6"). 4) In B3: =COUNTA(A:A). 5) In B4: =(B1-B2)/B3*100. With 80 promoters, 30 passives, and 40 detractors, B4 shows 26.7.

Practical lab

Understand it in a few minutes

  1. 01

    Classify scores with COUNTIF: 9–10 promoters, 7–8 passives, 0–6 detractors.

  2. 02

    NPS = % promoters − % detractors, always over the total of valid responses.

  3. 03

    In the ready-made NPSLab workbook, calculation, interpretation, and limits come built in.

How we reached this result

The formulas shown use only classic functions — COUNTIF, COUNTA, and arithmetic — available in every Excel version, Google Sheets, and LibreOffice. They are the same formulas used in the workbook NPSLab distributes.

What this calculation does not show

The spreadsheet computes the number; it does not validate the sample or replace reading the comments. Scores outside the 0–10 scale distort the group counts.

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

Prefer Excel? Take the calculators with you

Every calculator on this page in one free spreadsheet — works in Excel, Google Sheets, and LibreOffice, no macros. Edit the yellow cells and the result appears with its interpretation.

Download spreadsheet (.xlsx) Free · 7 calculators in one file · no sign-up
Direct answer

Frequently asked questions

What is the NPS formula for a spreadsheet?

=(COUNTIF(range,">=9")-COUNTIF(range,"<=6"))/COUNTA(range)*100. The same functions exist in Google Sheets and LibreOffice with identical names.

Do the formulas work in Google Sheets and LibreOffice?

Yes. COUNTIF and COUNTA exist in all three programs, and the ready-made NPSLab workbook opens in all of them with no macros and no installation.

How do I classify each score automatically?

Use =IF(A2>=9,"Promoter",IF(A2>=7,"Passive","Detractor")) next to each response to audit the group counts and double-check the classification.

Does the NPS result take a percent sign?

No. Although it is born from two percentages, NPS is expressed as a plain number from −100 to +100, usually as an integer or with one decimal.

Methodology

Sources, assumptions, and review

The references support the definitions and assumptions. The formula used is shown on this page and covered by automated tests.

Content and methodology maintained by the NPSLab team. Reviewed on .

Primary sources

Tools and learning
NPS calculatorOpen toolWhat is a good NPS score?Read the guideSample size calculatorOpen tool

Prefer to skip Excel? Create the survey in NPSLab and get your NPS calculated in real time.

Put the learning into a real survey and track every response in NPSLab.

Create a free survey