COUNTIFS on 2 check box columns, 1 checked, 1 unchecked

Jon Stikka

I am trying to write a formula for a sheet summary where an "Over Due" check box is checked (driven by a due date column), and a "Done" check box is not checked...

=COUNTIFS([Over Due]:[Over Due], 1, Done:Done, 0)

#Invalid Operation...

I originally tried to run a countifs based on Done = 0, and Due Date < TODAY, but learned you can't run a countifs using a date field, apparently.

what am I doing wrong?

Andrée Starå

Hi Jon,

You can run COUNTIFS with dates. Your other formula looks correct. Make sure the column types are correct.

Try something like this.

=COUNTIFS(Done:Done; 0; [Due Date]:[Due Date]; @cell < TODAY())

The same version but with the below changes for your and others convenience.

=COUNTIFS(Done:Done, 0, [Due Date]:[Due Date], @cell < TODAY())

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD