COUNTIFs for multiselect drop downs
I have a set of form responses where 350 colleagues have given their job level, and provided their 5 personal goals (in separate columns), and which of our organisational targets their goal aligns to.
They have selected the alignment to our organisational targets from a multiselect dropdown, and some people's goals align to more than one target.
I need to count how many times an organisational target has been selected in all the data. And also how many time it has been selected per job level.
I think I need to be using COUNTIFS and CONTAINS - but really struggling to get a formula to work. Would really appreciate some guidance!
Help Article Resources
Check out the Formula Handbook template!