Summary Task formula for COUNTIF Before TODAY and Status IS NOT "Not Started"
I'm looking for a summary task formula to count a row if the date is before today and Status value is NOT "Location Not Started". I've tried a few formulas and can't get to a working one. This is the last one I tried and getting and "Incorrect Argument" error message:
=COUNTIFS([Confirmed Install Date]:[Confirmed Install Date], <=TODAY(), IF(NOT([Combined Status]:[Combined Status] = "Location Not Started")))
Thank you for your help!
Help Article Resources
Check out the Formula Handbook template!