Saturday, December 17, 2011

yogi_Count Cells In A Range That Are Hyperlinked

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
user hurricane_ck said:
Count cells that use a specific function
I want to count how many cells in a column have a hyperlink in them, done using the HYPERLINK() function. I tried doing COUNTIF on both "HYPERLINK" and "http", but it doesn't count them. So, is there a way to count text that is part of a function?
in the following solution to the problem I have generalized from a column to a range wherein I count cells that begin with www. or http or mailto: