how to count checkboxes across multiple columns?

Bobby1

=COUNTIF([Missing Authorized Signature]:[Missing Authorized Signature], =1) + COUNTIF(Timesheet Does Not Match Invoice]:[Timesheet Does Not Match Invoice], =1)

Andrée Starå

Hi @Bobby1

I hope you're well and safe!

Isn't your formula working? It should.

Try something like this.

=
COUNTIF([Missing Authorized Signature]:[Missing Authorized Signature], 1) + 
COUNTIF([Timesheet Does Not Match Invoice]:[Timesheet Does Not Match Invoice], 1)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Bobby1

I hope you're well and safe!

Isn't your formula working? It should.

Try something like this.

=
COUNTIF([Missing Authorized Signature]:[Missing Authorized Signature], 1) + 
COUNTIF([Timesheet Does Not Match Invoice]:[Timesheet Does Not Match Invoice], 1)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Mike TV

@Bobby1

Additionally, if you're trying to only get a count of rows that have both checked, you'd want to use the COUNTIFS function like so:

=COUNTIFS([Missing Authorized Signature]:[Missing Authorized Signature], =1, [Timesheet Does Not Match Invoice]:[Timesheet Does Not Match Invoice], =1)

Andrée Starå

@Bobby1

Here's a simplified version because the columns are next to each other.

=COUNTIF([Timesheet Does Not Match Invoice]:[Missing Authorized Signature], 1)

Bobby1

@Andrée Starå OMGGGGGGG.

YES IT WORKED

Andrée Starå

@Bobby1

Excellent!

Happy to help!

Paula_

@Andrée Starå

I have similar need - two columns, right next to each other - but need to count them ONLY if both are checked. Can you help me on that? I have used what you shared and it works for the total count of both, but I need one that will only count the "line" if both are checked.

=COUNTIF([Producer Interview Completed]:[Client Interview Completed], 1)