NPS Excel or Google Sheets formula
I am not a fan of NPS, but sometimes having the copy and paste formula for Excel is helpful.
- Set up all the individual scores in a column and reserve 3 cells underneath.
- Paste these two formulas in the first 2 cells to find the number of Detractors and the number of Promoters. Remember, Passives don’t matter. Replace “RANGE” with the range from individual scores above
=COUNTIF(RANGE,”<=6″)
=COUNTIF(RANGE,”>=9″) - Time for the magic. Or tragic because you are about to give yourself an useless number, the NPS.
=(PROMOTER/COUNT(RANGE) * 100)-(DETRACTOR/COUNT(RANGE) * 100)