Counting Past Due Task on a Sheet

Sam MJH

Hello,

 

I'm trying to see if there is a way I can put a countifs function into a project plan template that will allow users to keep a rolling tally of any tasks not 100% complete and in the past.   Ideally i would like this to only look at milestones (0 duration) as i'm going to collect this from every sheet and place on a dashboard.    

 

Thank You,

 

 

Mike Wilday

Hello Sam, Try this.

=Countifs([Start Date]:[Start Date], < today(), Duration:Duration, =0)

J. Craig Williams

=Countifs([Start Date]:[Start Date], < today(), Duration:Duration, =0)

                                                                                                       ^

the equals sign is not needed.

Craig

Mike Wilday

Thanks Craig! Totally missed that. 

J. Craig Williams

No worries. It isn't wrong, just unnecessary.