# How to count a value with 2 range and criterion

Options

I'm trying to count all status that has "Change Complete" at HR Status Column within a specific month, say for the month of July from another column "Effective Date" (with date column property) and below was my formula but getting incorrect argument set error.

=COUNTIF([HR Status]:[HR Status], "Change Complete", [Effective Date]:[Effective Date], =MONTH(7))

Thank you in advance for the help.

• ✭✭✭✭✭✭
Options

Great to hear! The MONTH() function returns the month of the calendar year, so in the case of 7, it's returning any date that has the month of July.

You can get dynamic, depending on your use case, and use MONTH(@cell)=MONTH(TODAY()), and it would then always count the current month.

Jason Tarpinian - Sevan Technology

Smartsheet Aligned Partner

• ✭✭✭✭✭✭
Options

You'll want to use COUNTIFS to catch multiple criteria, so it would look something like:

=COUNTIFS([HR Status]:[HR Status], "Change Complete", [Effective Date]:[Effective Date], MONTH(@cell)=7

Jason Tarpinian - Sevan Technology

Smartsheet Aligned Partner

• Options

It worked!

I'm still learning how to use formulas with multi criteria, for this one can you please confirm that the value "7" on this part pertains to a specific month? MONTH(@cell)=7

• ✭✭✭✭✭✭
Options

Great to hear! The MONTH() function returns the month of the calendar year, so in the case of 7, it's returning any date that has the month of July.

You can get dynamic, depending on your use case, and use MONTH(@cell)=MONTH(TODAY()), and it would then always count the current month.

Jason Tarpinian - Sevan Technology

Smartsheet Aligned Partner

• Options

Awesome, thank you so much @Jason Tarpinian !

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!