Subdomain Removal Countifs


So I have a question regarding URLs in Libreoffice Calc.
I am a big data collector for the company that I work for and I regularly get URLs that are subdomains of domains as for example

Is there a way I can let the Formula to count how many times a certain word is used ignore the subdomain (‘cursus’ in this case) and focus on ‘’ instead? I am using the countifs function with this.

Is this even possible or?

Would love to hear from you all.


Don’t work ?

That doesn’t work, I just tried it. Thank you for the suggestion though. It’s the whole URL inside of a cell.

Please edit your question and explain in detail how you have formulated, with subdomains.