Is there a way to count the number of checked boxes in a row with multiple columns?
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
If needed, you could also add your countif statements together like this:
=COUNTIF([ColumnA]:[ColumnA], 1) + COUNTIF([ColumnJ]:[ColumnJ], 1) + COUNTIF([ColumnZ]:[ColumnZ])
I actually used this:
=SUM((COUNTIF([ColumnA]1:[ColumnD]1, 1))). I think it worked ok.
Thank you for the suggestions.
You shouldn't need the SUM() wrapper.
