I have been tasked to created a dashboard to capture all inquiries that have been closed by each responsible area on a monthly basis.
Here is the formula that I used and received and error message:
=COUNTIFS({National Alliance Operation Closed Inquiri Range 2}, {National Alliance Operation Closed Inquiri Range 1}, "NA.ITS.ESCALATIONS", AND(IFERROR(MONTH(@cell), 0) = 5, IFERROR(YEAR(@cell), 0) = 2020))