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!
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.
I figured out how to count the checkboxes, but I couldn't use that number in another formula. Am I missing something?
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.
Thank you! I don't know what I was doing wrong before, but it's working now.
