Trying to use COUNTIF with criteria from 2 columns.
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))
Help Article Resources
Check out the Formula Handbook template!