Forum Discussion

ML2021's avatar
ML2021
Copper Contributor
May 12, 2021
Solved

Count occurences in multiple selection list

Hi,   I am looking for the most efficient way to count the number of times a string occurs in a dataset, depending on the strings in another column.   For context, this is a survey style data set...
  • HansVogelaar's avatar
    May 12, 2021

    ML2021 

    Let's say location is in column A and products in column F.

     

    =COUNTIFS(A:A,"UK",F:F,"*Skincare*")

Resources