COUNTIF with AND function
I'm trying to count the instances that a contract has been executed and occurred in the year 2020. The formula I have unfortunately returns as "incorrect argument set". Any help would be greatly appreciated.
=COUNTIF([Status of Contract]:[Status of Contract], "Executed", AND([Date Received]:[Date Received], IFERROR(YEAR(@cell), 0) = 2020))
Help Article Resources
Check out the Formula Handbook template!