Problem with a COUNTIFS formula
Hello I am having problems with this formula =COUNTIFS(Date:Date, AND(IFERROR(YEAR(@cell), 0) = 2021, Reviewer:Reviewer, "IP")) I get a #INVALID DATA TYPE Error. Not sure what I am doing wrong.
Thank you for your help.
Best Answer
-
Hi @Ivan Perez
COUNTIFS doesn't need to have an AND statement because of the S at the end makes the function plural. This means you can list each range and criteria after another and the COUNTIFS knows that you mean "and"!
Try:
=COUNTIFS(Date:Date, IFERROR(YEAR(@cell), 0) = 2021, Reviewer:Reviewer, "IP")
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Check the column format settings, it may just be that the column was set to date format when it should be text.
Hope that helps, if it doesn't let us know.
AJ.
-
The Reviewer column is set up as a Dropdown (Single Selection) can that be causing the error.
-
Hi @Ivan Perez
COUNTIFS doesn't need to have an AND statement because of the S at the end makes the function plural. This means you can list each range and criteria after another and the COUNTIFS knows that you mean "and"!
Try:
=COUNTIFS(Date:Date, IFERROR(YEAR(@cell), 0) = 2021, Reviewer:Reviewer, "IP")
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you that work.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!