Formula to count individual option in multi select list within sheet summary
My sheet has a column called "Skills" which has 7 multi select options. I would like to include a sheet summary that counts how many times each option is selected.
In this screenshot the formula =COUNTM(Skills:Skills, "Policy writing") counts everything in the Skills column, not just "policy writing".
In the formula =COUNTIF(Skills:Skills, "Policy writing"), the sheet summary dosnt count "policy writing" where there is another skill in the cell for example, "project management".
Could anyone help with constructing the formula so that it counts all criterion?
My thanks in advance!
Help Article Resources
Check out the Formula Handbook template!