How can I count Hyperlinks?

I have a spread sheet with 100 jobs I have applied for from different job boards. They are listed in a large column as Hyperlinks. How can I count how many came from each job board?

Pseudo-Code:
=CountIFHyperlinkContains(A1:A100,"monster.com")

Sort of a take off on the real formula:
=COUNTIF(B1:B100,"*Applied April*")

Any ideas?

Hello Samualt,

Use this UDF code. The hyperlinks are a collection object that is part of each worksheet which is the Hyperlinks parentobject.

Please Login or Register  to view this content.

Worksheet Usage Example:
Cell A2 Formula: ="Sheet1"
Cell A1 formula: =CountHyperlinks(A2)

Sincerely,
Leith Ross