Jun 30 2020 11:36 AM
Hi, I am analyzing a survey for a client and need help with my formula.
I have to calculate the count for the following social media platforms Facebook, Twitter, LinkedIn, and Instagram.
The way the survey was exported shows multiple platforms selected per cell. It's not just a "COUNTIF" for each platform because the cell could have "Facebook, Instagram" or "Facebook, LinkedIn, Instagram" and so on.
Is there a simple and easy way to count? The only solution I've thought of, which is tedious, is counting every possible combination in an individual cell but that would still take really long. There must be some other way. I've attached a spreadsheet for reference.
Hope you can help and thanks in advance!
Jun 30 2020 11:52 AM
You may use something like
=COUNTIF(B:B,"*"&"LinkedIn"&"*")
or better
=COUNTIF(B:B,"*"&H1&"*")
if lookup word is in H1