CountIf Help

ggross

Is there a formula that would count the number of cells where a Done check is not completed but only when another columns due date is in the past?

 

The goal is to count how many past due tasks I have.  Does anyone know the best way to accomplish this?

 

 

Mike Wilday

=countifs([Done Check Column Name]:[Done Check Column Name], 0, [Due Date Column Name]:[Due Date Column Name], >Today()) 

Should give you a count of everything that is not checked and is in the past.