Checkbox Range Formula

hennarizvi

Hello-

 

Is there a formula that will check a box if another range of cells is also all checked?

 For example, I have a column that has 5 checkboxes in it.  I want another cell to also check off as soon as all 5 checkboxes in the column have been checked.

 

Nic Larsen

You can use something like this although there is probably a cleaner way to do the formula:

=IF(AND([Check Box]1 = 1, [Check Box]2 = 1, [Check Box]3 = 1, [Check Box]4 = 1, [Check Box]5 = 1), 1, 0)

Paul Newcome

=IF(COUNTIFS([Check Box]1:[Check Box]5, 1) = 5, 1)

 

It basically counts all of the boxes within the range that are checked. If that count comes to 5, then it will check the box.

hennarizvi

This worked! Thank you so much