Formula help: Counting user experience by date
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
Help Article Resources
Check out the Formula Handbook template!