Formula to count status and due date in the past

Simone Georgiou

Hi, hoping that someone can help...

I'm trying to add a field into my Sheet Summary, to highlight tasks that are overdue, but need to excluded tasks that are 'Complete'. This is what I've tried, however the error message is #Unparseable.

=COUNTIF(Launch:Launch), <TODAY(), + COUNTIF(Status:Status, "In Progress"), (Status:Status, "Under Analysis")

Any ideas? Thank you

Aravind GP

Hi Simone,

It will be helpful if you can give a screenshot. You can possibly use this formula.

=COUNTIFS(Status:Status, "In Progress", Launch:Launch, <TODAY()) + COUNTIFS(Status:Status, "Under Analysis", Launch:Launch, <TODAY())

Simone Georgiou

Perfect, thank you! This is what has worked :)

=COUNTIFS(Status:Status, "In Progress", Launch:Launch, @cell < TODAY()) + COUNTIFS(Status:Status, "Under Analysis", Launch:Launch, @cell < TODAY())

For some reason if I excluded the '@cell' it didn't work, but it's all good now!