Cross sheet count if.

Looking to count from a contact column the number of times a name appears for any one month and year. The below resulting in #unparseable, a variation of resulted in #Invalid Argument set?
=COUNTIFS({Completed Dispatches Range 1}, AND(IFERROR(YEAR(@cell), 0) = 2023, IFERROR(MONTH(@cell), 0) = Category@row)) > 0, COUNTIFS({Completed Dispatches Range 1}, AND(IFERROR(YEAR(@cell), 0) = 2023, IFERROR(MONTH(@cell), 0) = Category@row, {Completed Dispatches Range 2}, CONTAINS("jason", @cell))))
Regards
Cheers.
Best Answer
-
Worked it...
=COUNTIFS({Completed Dispatches Range 3}, CONTAINS("Jason", @cell), {Completed Dispatches Range 2}, IFERROR(MONTH(@cell), 0) = Category@row, {Completed Dispatches Range 2}, AND(IFERROR(YEAR(@cell), 0) = 2023))
Cheers.
Answers
-
Yeah, that's a hot mess. If nobody answers in the next 12 hours I'll stab at it. too lazy now.
-
Worked it...
=COUNTIFS({Completed Dispatches Range 3}, CONTAINS("Jason", @cell), {Completed Dispatches Range 2}, IFERROR(MONTH(@cell), 0) = Category@row, {Completed Dispatches Range 2}, AND(IFERROR(YEAR(@cell), 0) = 2023))
Cheers.
-
Nice one mate.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 206 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 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!