Jun 10 2021 12:47 AM
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 ?
Jun 10 2021 02:18 AM
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*")
Jun 10 2021 03:27 AM
@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
Jun 10 2021 03:30 AM
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*")
Jun 10 2021 03:50 AM