count overdue dates and ignore blanks using countifs


So far I have this and spent 1/2 hour plus trying to understand isblank and error trapping in the forums but can't quite knit everything together.

=countifs(cc:cc,"120802",[Due Date], <=TODAY)

Background - cc column I want to show only 120802 and for the Due Date column only count those dates < today's date. My problem is not all tasks have allocated dates, so need to ignore.

I thought this would have been straightforward, but I am missing something.Thanks in advance Paul

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!