Linkcount matching a certain Xpath?

Support
#1

Hi,

Is there anyway to use linkcount function with a certain Xpath to get link count from certain nodes of a page?

For example, I wish to count link used within the text on a certain area of the page (only first paragraph or the last before the footer). If I use Xpath with the countA function, it even counts blankcells as 1.

Any other workaround would be highly appreciated.

Thanks,

#2

How about this? Adjust the XPath according to your page filtering

image
image897×438 49.3 KB

#3

Thanks for your response. I tried the same function but when it's 0 internal link it still counts it as 1 since the blank cells are also counted with COUNTA function.

#4

Try like this:
=SUMPRODUCT(--(XPathOnUrl(url;xpath;attribute)<>""))

1 Like