# Counting if there is more than 1 condition

Options

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

• Options

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

• ✭✭✭✭✭✭
Options

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

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!