HELP: Countif or Countifs formula for survey analysis

%3CLINGO-SUB%20id%3D%22lingo-sub-1499698%22%20slang%3D%22en-US%22%3EHELP%3A%20Countif%20or%20Countifs%20formula%20for%20survey%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1499698%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20analyzing%20a%20survey%20for%20a%20client%20and%20need%20help%20with%20my%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20calculate%20the%20count%20for%20the%20following%20social%20media%20platforms%20Facebook%2C%20Twitter%2C%20LinkedIn%2C%20and%20Instagram.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20way%20the%20survey%20was%20exported%20shows%20multiple%20platforms%20selected%20per%20cell.%20It's%20not%20just%20a%20%22COUNTIF%22%20for%20each%20platform%20because%20the%20cell%20could%20have%20%22Facebook%2C%20Instagram%22%20or%20%22Facebook%2C%20LinkedIn%2C%20Instagram%22%20and%20so%20on.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20simple%20and%20easy%20way%20to%20count%3F%20The%20only%20solution%20I've%20thought%20of%2C%20which%20is%20tedious%2C%20is%20counting%20every%20possible%20combination%20in%20an%20individual%20cell%20but%20that%20would%20still%20take%20really%20long.%20There%20must%20be%20some%20other%20way.%20I've%20attached%20a%20spreadsheet%20for%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20you%20can%20help%20and%20thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1499698%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1499750%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%3A%20Countif%20or%20Countifs%20formula%20for%20survey%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1499750%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F714653%22%20target%3D%22_blank%22%3E%40100819116%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20something%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCOUNTIF(B%3AB%2C%22*%22%26amp%3B%22LinkedIn%22%26amp%3B%22*%22)%0Aor%20better%0A%3DCOUNTIF(B%3AB%2C%22*%22%26amp%3BH1%26amp%3B%22*%22)%0Aif%20lookup%20word%20is%20in%20H1%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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!

1 Reply
Highlighted

@100819116 

You may use something like

=COUNTIF(B:B,"*"&"LinkedIn"&"*")
or better
=COUNTIF(B:B,"*"&H1&"*")
if lookup word is in H1