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.

1. Set up all the individual scores in a column and reserve 3 cells underneath.
2. 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″)
3. 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)