Formula for Counting Checkboxes in a row

Ana Padilla

Is there a way to count the number of checked boxes in a row with multiple columns?

J. Craig Williams

Are the columns sequential?

You could try

 

=COUNTIF([Column1]23:[ColumnN]23,1)

for row 23 and replacing the column names with the first and last column names in the sheet.

 

You will get false positives on any column with the value 1 or "1"

There's no way to tell it to only count check boxes.

 

Craig

 

Shaine Greenwood

If needed, you could also add your countif statements together like this:

 

=COUNTIF([ColumnA]:[ColumnA], 1) + COUNTIF([ColumnJ]:[ColumnJ], 1) + COUNTIF([ColumnZ]:[ColumnZ])

Ana Padilla

I actually used this:

=SUM((COUNTIF([ColumnA]1:[ColumnD]1, 1))).  I think it worked ok. 

Ana Padilla

Thank you for the suggestions. 

 

J. Craig Williams

You shouldn't need the SUM() wrapper.

 

Craig