Net Promoter Score Calculation
Hi all,
I'm stumped on a formula (again!)
I'm looking to ascertain a NPS and I've got the following going on:
Promoters: =COUNTIF([How likely are you to recommend NCR to a colleague]:[How likely are you to recommend NCR to a colleague], ">=9")
Detractors: =COUNTIF([How likely are you to recommend NCR to a colleague]:[How likely are you to recommend NCR to a colleague], ">=6")
Total responses: =COUNTIFS([How likely are you to recommend NCR to a colleague]:[How likely are you to recommend NCR to a colleague], "<>")
On the basis NPS is % of promoters - % of detractors, I'm using this to get my NPS but it's an Incorrect Argument Set. It could be a lack of brackets?
=COUNTIF(Promoters# - Detractors# / [Total responses]# * 100)
What am I missing?
Thanks in advance.
Answers
-
Apologies - slight error in Detractors, it should read:
=COUNTIF([How likely are you to recommend NCR to a colleague]:[How likely are you to recommend NCR to a colleague], "<=6")
-
Fixed it!
Replaced Countif for Sum. Rookie error!
:)
-
@KatieDi Would you mind providing a screen shot or two of your sheet and then the full formulas strung together? I am having a hard time laying mine out so. Thank you in advance.
Help Article Resources
Categories
Check out the Formula Handbook template!