Sheet Summary Formula

Seatora

I have a formula question that I’m hoping you can help me with. I have a multi-select drop-down in the Stakeholder Department(s) column, which contains several department names. I’m trying to create a sheet summary that counts the number of times any one of these department names appear in that column. I’m currently using the following – and it’s not working. (It looks like it might only be counting the first entry in each cell in that column.) =COUNTIF([Stakeholder Department(s)]1:[Stakeholder Department(s)]35, "Business Ops.") Any advice on how to achieve this?

Peggy Parchert

Hello @Seatora

Hope this finds you well. Try this:

=COUNTIF([Stakeholder Department(s)]:[Stakeholder Department(s)], "Business Ops")

-Peggy

Joleen Rasmussen

I am trying to do something similiar. The fomula seems to count the occurance if is the only value listed. My Concern column allows for mutliple values. =COUNTIF(Concern:Concern, "No call no show")