Count: status is one of multiple criteria and due date is past

System

This discussion was created from comments split from: COUNTIFS function with multiple criteria.

Michael Shelley

I am also having issues with this function. I have two columns of data Dependency Status and Due Date.

I want to return a count of rows where the dependency status is one of multiple criteria and the due date is past today.

Here is what I have been trying.

COUNTIFS([Dependency Status]:[Dependency Status], OR(@cell = "abandoned", @cell = "Complete"), [Due Date]:[Due Date], @cell > TODAY())

It parses but returns a count of 0. If I run each individual range and criteria It returns the correct count.

Paul Newcome

@Michael Shelley It looks like the formula you have posted should be working. Are you able to apply a filter to the sheet to mimic the formula and see how many rows are presented? Are you able to provide a screenshot of a few rows that meet the criteria?

Michael Shelley

@Paul Newcome Thanks for jumping in to help!

Here is my filter which returns 2 rows which is what I would expect based off my test data.

Here are the two rows returned.

Paul Newcome

Ah. Ok. Switch the operator in your formula before the TODAY function. You are currently saying to find dates greater than today which would be in the future. You need less than.

Michael Shelley

UUGH!! Such a simple miss. Thank you that did it.

Paul Newcome

Happy to help. 👍️