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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!