IF Function

%3CLINGO-SUB%20id%3D%22lingo-sub-2433871%22%20slang%3D%22en-US%22%3EIF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2433871%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20find%20a%20Formula%20which%20counts%20how%20often%20a%20Company%20wrote%20for%20example%20%E2%80%9Cdigital%E2%80%9D%20on%20their%20website%20Perfect%20would%20be%20to%20just%20count%20the%20keyword%20if%20the%20URL%20has%20another%20keyword%20(for%20example%20Imprint%20or%20blog)%20in%20it%3C%2FP%3E%3CP%3Ethe%20thing%20is%20that%20I%20really%20don't%20know%20how%20to%20make%20it%20..%20any%20help%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2433871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2434269%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2434269%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1075459%22%20target%3D%22_blank%22%3E%40laraharmouch95%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20example%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIFS('www%20gastronovi%20com_de_'!B%3AB%2C%22*digital*%22%2C'www%20gastronovi%20com_de_'!B%3AB%2C%22*blog*%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20German%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DZ%C3%84HLENWENNS('www%20gastronovi%20com_de_'!B%3AB%3B%22*digital*%22%3B'www%20gastronovi%20com_de_'!B%3AB%3B%22*blog*%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2434435%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2434435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1075459%22%20target%3D%22_blank%22%3E%40laraharmouch95%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20about%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIFS('www%20gastronovi%20com_de_'!B%3AB%2C%22*digital*%22%2C'www%20gastronovi%20com_de_'!A%3AA%2C%22*blog*%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DZ%C3%84HLENWENNS('www%20gastronovi%20com_de_'!B%3AB%3B%22*digital*%22%3B'www%20gastronovi%20com_de_'!A%3AA%3B%22*blog*%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I need to find a Formula which counts how often a Company wrote for example “digital” on their website Perfect would be to just count the keyword if the URL has another keyword (for example Imprint or blog) in it

the thing is that I really don't know how to make it .. any help ?

6 Replies

@laraharmouch95 

For example:

 

=COUNTIFS('www gastronovi com_de_'!B:B,"*digital*",'www gastronovi com_de_'!B:B,"*blog*")

 

In German:

 

=ZÄHLENWENNS('www gastronovi com_de_'!B:B;"*digital*";'www gastronovi com_de_'!B:B;"*blog*")

@Hans Vogelaar  the thing is that there should be connection between column A and B because i want to count keywords under the condition that the URL has the possibility to have an another keyword 

@laraharmouch95 

How about

 

=COUNTIFS('www gastronovi com_de_'!B:B,"*digital*",'www gastronovi com_de_'!A:A,"*blog*")

 

=ZÄHLENWENNS('www gastronovi com_de_'!B:B;"*digital*";'www gastronovi com_de_'!A:A;"*blog*")

unfortunatly no because i also have to add only two attributes to the formula not 4

@laraharmouch95 

I'm sorry, you've lost me.

thank you anyway