nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

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!

Comments

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.