4

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,

 

 

Comments

Hello Sam, Try this.

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

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

                                                                                                       ^

the equals sign is not needed.

Craig