Countifs for if either column is checked

I have two checkbox columns and need to get a count of how many rows have either or both of the check boxes checked. I am struggling on how the formula to accomplish this is the sheet summary.

Below is my current equation for getting the count of one of the columns, I am able to do this for both to get a count for each column, but if I add the numbers it ends up being higher due to some rows having both boxes checked.

=COUNTIFS([Date Submitted]:[ Date Submitted], AND(@cell >= [Previous Tuesday]#, @cell <= [Current Tuesday]#), [Check 1]:[Check 1], 1)

Find more posts tagged with

Formulas

Accepted answers

Melissa Yamada

Hello @Nick0000

Try this:

=(COUNTIFS([Date Submitted]:[ Date Submitted], AND(@cell >= [Previous Tuesday]#, @cell <= [Current Tuesday]#), [Check 1]:[Check 1], 1) + COUNTIFS([Date Submitted]:[ Date Submitted], AND(@cell >= [Previous Tuesday]#, @cell <= [Current Tuesday]#), [Check 2]:[Check 2], 1)) - COUNTIFS([Date Submitted]:[ Date Submitted], AND(@cell >= [Previous Tuesday]#, @cell <= [Current Tuesday]#), [Check 1]:[Check 1], 1,[Check 2]:[Check 2], 1)

All comments

Melissa Yamada

Hello @Nick0000

Try this:

Nick0000

Thank you Melissa!

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.