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
  3. Time for the magic. Or tragic because you are about to give yourself an useless number, the NPS.

Have your say

This site uses Akismet to reduce spam. Learn how your comment data is processed.