How can I write a COUNTIFs using a dropdown in one argument and not another?

I have 2 columns that I am trying to do a sheet summary on and can't figure best way to write. one column is a free text and the other column is a drop down list with several months. I need to get the counts of "Leaders" who select certain months (Oct, Nov, Dec, etc). Can this be done using CONTAINS ?

=COUNTIFS($[Leader or Talent]:$[Leader or Talent], "Leader"; AND $[Months Invite Accepted]:$[Months Invite Accepted],(CONTAINS "Nov FY23")

Find more posts tagged with

Formulas

Accepted answers

All comments

Shubham

Hi Jillian C.

I hope you're doing well.

As per your requirements you can use this formula.

=COUNTIFS([Leader or Talent]:[Leader or Talent], "Leader", [Months Invite Accepted]:[Months Invite Accepted], "Oct.")

And according to Sheet Summary Field you can change the condition for different month. For ex – instead of Oct use Nov, Dec etc.

I hope this helps you, Have a Good Day.

Thanks

Shubham Umale, Smartsheet Engineer, Ignatiuz Software

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