Formula help: Counting user experience by date

Options

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

Tags:

• ✭✭✭✭✭✭
Options

In that case the criteria for that range should be

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

the above replaces

"September"

• ✭✭✭✭✭✭
Options

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.

• Options

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

• ✭✭✭✭✭✭
Options

Is {Range 6} referencing the date column?

• Options

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

• ✭✭✭✭✭✭
Options

In that case the criteria for that range should be

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

the above replaces

"September"

• Options

Thank you!!!!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!