Counting check boxes in a row if "Yes" is written in a cell in the same row

ICue

The following formula works for counting my check boxes but I cannot seem to figure out how to write the rest of the formula to only count the check boxes in my row if "Yes" is written in a cell in the same row. Help please!

=COUNTIF([Building Perimeter Verified]@row:[Reminder Email Sent]@row, =1)

Thanks so much!

Paul Newcome

Try using the COUNTIF as the output for an IF statement.

=IF([Column Name]@row = "Yes", COUNTIF([Building Perimeter Verified]@row:[Reminder Email Sent]@row, =1))

ICue

Thank you so much, Paul! Exactly what I needed!

Paul Newcome

Try using the COUNTIF as the output for an IF statement.

=IF([Column Name]@row = "Yes", COUNTIF([Building Perimeter Verified]@row:[Reminder Email Sent]@row, =1))

ICue

Thank you so much, Paul! Exactly what I needed!

Paul Newcome

Happy to help! 👍️