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?

Find more posts tagged with

Formulas

Accepted answers

Andrée Starå

Hi @CoryG

I hope you're well and safe!

If the columns with the different options are side by side, you could try something like this in a checkbox column to have it checked if more than one option is Yes.

=IF(COUNTIF(Hispanic@row:[Pacific Islander]@row, "Yes") > 1, 1)

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @CoryG

I hope you're well and safe!

If the columns with the different options are side by side, you could try something like this in a checkbox column to have it checked if more than one option is Yes.

=IF(COUNTIF(Hispanic@row:[Pacific Islander]@row, "Yes") > 1, 1)

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

CoryG

@Andrée Starå Sorry for the delayed response. Hope your week is going well. That worked perfectly! Thank you so much. Your a Hero!

Andrée Starå

@CoryG

No worries!

Glad to hear that it's working, and you're more than welcome!

My week is going fantastic, and I hope yours is too!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.