Count Past Due Task and Exclude Status that is Complete

RJT

I am trying to count past due tasks but exclude any tasks that are past the End Date. Below is my current logic that is NOT working.

=COUNTIFS({P904 - Walkthrough Past Due}, AND(@cell < TODAY (), AND(@Cell <> "Complete" )))

Below is logic that is counting all items that are past the End Date
=COUNTIFS({P904 - Walkthrough Past Due}, <TODAY())

Below are the Sheet Fields

James Keuning

You don't the second AND

Edit to add: if that does not work, I would create a checkbox column that tests your AND statement, and then use that column as the second COUNTIFS criteria.

heyjay

=COUNTIFS(
{P904 - Walkthrough Past Due}, < TODAY(),
Status:Status, <> "Complete"

RJT

Attempted

=COUNTIFS({P904 - Walkthrough Past Due}, < TODAY(), Status:Status, <> "Complete")

Continue to get #UNPARSEABLE.

Paul Newcome

Is "Status:Status" supposed to be a {Cross Sheet Reference}?

RJT

Paul…Statu:Status is the column in the reference sheet P904 - Walkthrough Past Due.

Paul Newcome

If it is a reference to a sheet that the formula is not housed on, you need to create another {Cross Sheet Reference} the same way you did for the first range.