Formula help: Counting user experience by date

Hi there,

I am trying to create a formula to count by user experience (e.g., Positive, negative, Neutral, N/A) for each month. For example count if a response is in September and it is positive.

I am referencing a different sheet and I have tried a few different formulas but I keep getting errors.

I am assuming I need to use =COUNTIFS - however, I cannot get the formula to work and I know it's a user error on my end.

Here is a bit of dummy data from my reference sheet

Any help would be greatly appreciated

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

In that case the criteria for that range should be

IFERROR(MONTH(@cell), 0) = 9

the above replaces

"September"

All comments

Paul Newcome

If you share the COUNTIFS you are currently trying to get to work, I'd be happy to help walk you the rest of the way through it.

Shep_holly_10

@Paul Newcome - thanks for your offer to help!

I have tried a few - but here is one that comes up with 0 but should have two results.

=COUNTIFS({Beta Survey Results Range 6}, "September", {Beta Survey Results Range 7}, "n/a")

Paul Newcome

Is {Range 6} referencing the date column?

Shep_holly_10

@Paul Newcome - yes!

Range 6 is a date column - the format is typed out "month, date, year" (e.g., September 4, 2023)

Range 7 is the classification (e.g., Positive, Negative, Neutral, N/A)

Paul Newcome

In that case the criteria for that range should be

IFERROR(MONTH(@cell), 0) = 9

the above replaces

"September"

Shep_holly_10

Thank you!!!!

Paul Newcome

Happy to help. 👍️

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.