Trying to use COUNTIF with criteria from 2 columns.

Amy Violette

I have 2 columns I want to pull from, one is Issue Status should equal 'Open', and second is Target Date which I only want to count if it's in the past. Below is the formula I have, but I'm getting an error.

=COUNTIFS([ERM Target Date]:[ERM Target Date], @cell < TODAY(),[Issue Status]:[Issue Status], [Issue Status]2))

Paul Newcome

Try removing one of the closing parenthesis from the end.

Paul Newcome

Try removing one of the closing parenthesis from the end.

Amy Violette

Awesome! Thank you that worked!

Paul Newcome

Happy to help. 👍️