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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!