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



  • Shubham
    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. 


    Shubham Umale, Smartsheet Engineer, Ignatiuz Software 

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!