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

Find more posts tagged with

Accepted answers

All comments

Josephine

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))

Andrée Starå

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.