Net Promoter Score Calculation

KatieDi

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.

KatieDi

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")

KatieDi

Fixed it!

Replaced Countif for Sum. Rookie error!

:)

Kristen Zachwieja

@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.