Looking for a Formula that will count if multiple values are true
I am working to keep track of under represented minorities we have in our classes. We are able to get a formula that keeps track if they belong to one Like Hispanic or American Indian, but we do have some students who belong to more than one of these group. We use this formula for Instance to gather if they were Hispanic
=COUNTIFS([Declined / Deferred?]:[Declined / Deferred?], ="", Hispanic:Hispanic, "yes")
Say we have these columns set, Hispanic, American Indian, Asian, Black, Pacific Islander. Is there a way to have a formula that will keep track if any Student is Yes to any 2 or more of these?
Help Article Resources
Check out the Formula Handbook template!