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.

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.