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

Jillian C.

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

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