# Using formulas to count checkboxes

I’m stumped on something that’s likely very simply.

I’m needing to count the number of checkboxes present on a pulse. What formula can I use for this? Example photo shows an instance where we would want the QA score to show as 4.

Hey Erin,

Try this formula:

`IF(AND({Checkbox}>0,{Checkbox 1}>0, {Checkbox 2}>0, {Checkbox 3}>0), 4, 0)`

If you’d instead like for the output to show the number of boxes checked, you can use this:

`IF({Checkbox}>0, 1, 0) + IF({Checkbox 1}>0, 1, 0) + IF({Checkbox 2}>0, 1, 0) + IF({Checkbox 3}>0, 1, 0)`

As a final alternative, you can also display the output as a fraction of the total amount:

`(IF({Checkbox}>0, 1, 0) + IF({Checkbox 1}>0, 1, 0) + IF({Checkbox 2}>0, 1, 0) + IF({Checkbox 3}>0, 1, 0)) & "/4"`

I hope this helps - let me know if you run into any issues

1 Like

I had actually resolved this already, but seeing that there are multiple ways to make this works is super helpful for future instances. Thank you!

1 Like

Glad to hear you got this sorted! No problem

Is there a similar formula that could be used for counting number of checked boxes in a column, rather than a row?

I would love to have check boxes with subitems and have a column for the regular item that has a count of the number of subitems that have been checked.

Unfortunately, formulas can’t calculate vertically, only horizontally, like a row. Likewise, you can’t create a formula that includes the column summary (yet!).