check box formula

Danfenti

I am trying to get a check box to automatically check itself when a range of other check boxes are checked off, I have tried a few formulas with no luck, below is my latest formula

 

=IF([Sand 1]294:[Sand 1]310 = 1), 1)

Greg Gates

I think you can get your desired functionality using the COUNTIF function combined with an IF-statement. If you wanted to mark a box if 7 specific checkboxes are all checked, then you might write something like this:

=IF(COUNTIF([Checkbox Column 1]1:[Checkbox Column 1]7,1)=7,1,0)

 

Basically the formula says:

1. Count all of the boxes that are checked (equal to 1)
2. If the count of these boxes is equal to 7 (the number of boxes in my range), then check this current box, otherwise, don't

 

I hope that works for you!