Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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?
----------------------------------
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:
No comments:
Post a Comment