Countifs (MultiSelect Dropdown), (Unchecked box)
Hello!
I am confused about how to write this countif.
I need a count that represents the total number of students who have enrolled into each type of school that are eligible for a scholarship.
The type of school is a drop down, which I can get the count by using the code below. I tack on the -1, because I use the drop down as part of my key and need to make sure it isn't included. This function works perfectly fine.
=COUNTIFS(Enrollment:Enrollment, CONTAINS("4", @cell)) - 1
I am also able to get the count of unchecked boxes to count fine on it's own using the following code:
=COUNTIFS(NotEligible:NotEligible, 0)
But, now that I need to see what the count is for the intersection of this group, I keep getting the error "#unparsable". I'm trying the following code and tried playing with some variations with no luck.
=COUNTIFS(Enrollment:Enrollment, CONTAINS("4", @cell)), (NotEligible:NotEligible, 0)-1
Am I missing something?
TIA!
Best Answer
-
YOu hav Extra () in unneeded locations. Below i corrected this syntax error
=COUNTIFS(Enrollment:Enrollment, CONTAINS("4", @cell), NotEligible:NotEligible, 0)-1
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
YOu hav Extra () in unneeded locations. Below i corrected this syntax error
=COUNTIFS(Enrollment:Enrollment, CONTAINS("4", @cell), NotEligible:NotEligible, 0)-1
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Thank you!!!! This worked perfectly!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!