Count tags within a multi select column

Heaven Casher

Hello,

What formula would I use count a multi select option with a certain condition? For example in this data set, I want to count the number of times IP1 occurs in Phase 1b:

Thanks!

Ric T

Hi @Heaven Casher,

Try this formula:

=COUNTIFS(Groups:Groups, HAS(@cell, "IP1"), Phase:Phase, "Phase 1b")

Note, you'll need to modify the formula to fit the name of your columns. In the formula above, I've named the column which contains your multi-select values as "Groups", and the column which contains the different phases as "Phase".

Cheers,

Ric