COUNTIF with AND function

Hi there,
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))
Best Answer
-
When dealing with multiple criteria, you need to use COUNTIFS (plural) instead of COUNTIF (singular). As a point of note, COUNTIFS (plural) can always be used, regardless if one criteria or many. Note that the criteria within the COUNTIFS are already 'AND' criteria
=COUNTIFS([Status of Contract]:[Status of Contract], "Executed", [Date Received]:[Date Received], IFERROR(YEAR(@cell), 0) = 2020)
cheers,
Kelly
Answers
-
When dealing with multiple criteria, you need to use COUNTIFS (plural) instead of COUNTIF (singular). As a point of note, COUNTIFS (plural) can always be used, regardless if one criteria or many. Note that the criteria within the COUNTIFS are already 'AND' criteria
=COUNTIFS([Status of Contract]:[Status of Contract], "Executed", [Date Received]:[Date Received], IFERROR(YEAR(@cell), 0) = 2020)
cheers,
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!