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!
