Task not complete and overdue

PMOGal

I have a % Complete field and a Finish date field. When % Complete <>100% and the Finish date is in the past, what COUNTIF formula do I use? Also, some Finish dates may be blank as they have not yet been given a date. Thank you.

Paul Newcome

You would use something like this:

=COUNTIFS([% Complete]:[% Complete], @cell <> 1, Finish:Finish, AND(@cell <> "", @cell < TODAY()))

PMOGal

I think I have it:

=COUNTIFS([% Complete]:[% Complete], <1, Finish:Finish, <TODAY())

Paul Newcome

Yes. That should work too. I generally do the AND function to definitely make sure it excludes blanks.