Counting if there is more than 1 condition

Josephine

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

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!