Sign in to join the conversation:
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.
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.
