Counting if there is more than 1 condition


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!