Checkbox % formula

Dawn

I have a checkbox column, no children, and I want to calculate what percentage of the checkboxes are checked for a specific range.  Is there a formula that could do that?

 

Thank you!

Daryl Horrocks

Yes this formula will count how many are checked: =COUNTIF([1]1:[1]5, true)

 

 Then you'd just have to do a separate count for all cells in the range, and divide the two numbers.

Dawn

I figured out how to count the checkboxes, but I couldn't use that number in another formula.  Am I missing something?

Daryl Horrocks

Once you get the result, you'd set up another formula to count all cells within a range. Your third cell would compute those two number. Is that what you tried? Like this attached.

Dawn

Thank you!  I don't know what I was doing wrong before, but it's working now.