I am trying to add total count of column highlighted with a check box and for some reason am stumped

Wendy Gaines

Wendy Gaines

I am trying to add the formula from my reference sheet here but it says unparseable

Carson Penticuff

Do you mean you are trying to count how many rows have a check in that column?

Since "checked" = 1 and "unchecked" = 0, you can just sum the column.

=SUM([Denied due to Behavior Checked]:[Denied due to Behavior Checked])

Wendy Gaines

I am trying to add the formula from my reference sheet here but it says unparseable

Carson Penticuff

Are you attempting to place the formula in a different sheet from the source? You will need to setup a cross-sheet reference in the sheet you are placing the formula which references the relevant column in your reference sheet. This formula should then give you the result.

=COUNTIFS({Denied due to Behavior Checked}, 1)