How to use COUNTIF and IFERROR when referencing another sheet
=COUNTIFS({Committee Approval Status/Estado de Aprobacion}, "Approved / Aprobado", {Nominee's Work Location}, "Western", IFERROR(YEAR({Payroll Date}), 0) = 2025)
Best Answer
-
It should still be in the same syntax of range, criteria.
=COUNTIFS(……………………………….., {Payroll Date}, IFERROR(YEAR(@cell), 0) = 2025)
Answers
-
It should still be in the same syntax of range, criteria.
=COUNTIFS(……………………………….., {Payroll Date}, IFERROR(YEAR(@cell), 0) = 2025)
-
Thank you! That worked
-
=COUNTIFS({Committee Approval Status/Estado de Aprobacion}, "Approved / Aprobado", {Nominee's Work Location}, "Western", {Payroll Date}, IFERROR(YEAR(@cell ), 0) = 2024, ({Award Type}), "Starbucks - $25 gift card", "Western", {Authorized Date}, IFERROR(YEAR(@cell ), 0) = 2024)@cell
I need to add authorized date for a specific award because that award does not have a payroll date. I can't seem to put both payroll and authorized date together
-
Are you trying to do one or the other? If so, you will need to write two COUNTIFS (one for each of the date columns) and then add them together.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.4K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 493 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!