Using COUNTIFS with multiple criteria-need help!
Hi everyone, I am trying pull a count that has the following information on my sheet
-"other" in the Focus Area Column
-"Disagree" in the Resources 1, 2 or 3 columns
-"Strongly Disagree" in the Resources 1,2 or 3 columns
I have the formula below, but it's giving me the "Incorrect Argument Set" error
Can someone help me sort this out please, thank you!
=COUNTIFS({DCYF OneWA Pulse-checks Range 1}, Answers@row, {DCYF OneWA Pulse-checks Range 11}, "Disagree", {DCYF OneWA Pulse-checks Range 11,"Strongly Disagree"})
Answers
-
Looks like a bracket is out of place - try:
=COUNTIFS({DCYF OneWA Pulse-checks Range 1}, Answers@row, {DCYF OneWA Pulse-checks Range 11}, "Disagree", {DCYF OneWA Pulse-checks Range 11},"Strongly Disagree")
But I'll add, if the range is covering all three columns, I can't recall if a Countif can do that or not. You may need to make a new range for each column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!