Forum Discussion
ML2021
May 12, 2021Copper Contributor
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...
- May 12, 2021
Let's say location is in column A and products in column F.
=COUNTIFS(A:A,"UK",F:F,"*Skincare*")
HansVogelaar
May 12, 2021MVP
Let's say location is in column A and products in column F.
=COUNTIFS(A:A,"UK",F:F,"*Skincare*")
- ML2021May 12, 2021Copper Contributor
thanks so much! HansVogelaar