Countifs for if either column is checked

Nick0000 · 03/21/25

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)

Melissa Yamada · 03/22/25

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)

Melissa Yamada · 03/22/25

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)

Nick0000 · 03/24/25

Thank you Melissa!

Formulas and Functions

Formulas and Functions

Countifs for if either column is checked

Best Answer

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Formula Help: Multiple if conditions

Is There A Way To Set A Character Limit?

copy paste and predecessors rows