Countifs for if either column is checked

Nick0000

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

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

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

Thank you Melissa!