Counting if there is more than 1 condition
Hello,
I have a sheet where we collate applications from candidates.
Starting another sheet to gather the data.
I have the first formula sorted to count the applicants per month-
=COUNTIF({2022 Resume Tracker Range 1}, AND(IFERROR(MONTH(@cell), 0) = Month@row, IFERROR(YEAR(@cell), 0) = Year@row))
But now I am trying to count in the main sheet number of candidates that applied per region, per month i.e. Number that applied during Oct for South Island.
I have tried -
=COUNTIF({2022 Resume Tracker Range 1}, AND(IFERROR({2022 Resume Tracker Range 2}, 0) = "South Island", IFERROR(MONTH(@cell), 0) = Month@row, IFERROR(YEAR(@cell), 0) = Year@row))
But it isn't working. Range 1 links to the date column, range 2 links to the column with the region
Answers
-
Figured it out!
=COUNTIFS({2022 Resume Tracker Range 3}, OR(@cell = "South Island"), {2022 Resume Tracker Range 1}, AND(IFERROR(MONTH(@cell), 0) = Month@row, IFERROR(YEAR(@cell), 0) = Year@row))
-
Hi @Josephine
I hope you're well and safe!
Excellent! Glad you got it working!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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!