How to count a value with 2 range and criterion

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.

Find more posts tagged with

Accepted answers

Jason Tarpinian

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.

All comments

Jason Tarpinian

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

Sespedido_23

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

Jason Tarpinian

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.

Sespedido_23

Awesome, thank you so much @Jason Tarpinian !

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.