CODEWITHSUNDEEP
arraysgoogle-sheetsgoogle-sheets-formulacountingcountif
Tharm Bood
Tharm Bood

Reputation: 13

Counting instances of text in a formula in Google Sheets?

I'm trying to count the amount of times certain certain text pops up in a Formula, but struggling to get it to check more than one cell. For context, the purpose is to count the amount of times a URL appears in a column, to count the amount of externally confirmable information in the sheet. My current forumla is:

=countif(formulatext(C2:C),CONCATENATE("*","http","*"))

In the instance where C2 and C3 both contain 

=Hyperlink("[URL]","[Title]")

As of current, it only counts C2, Outputting "1" if C2 meets the requirement, or "0" if it doesn't, C3 onwards are ignored. It should check each cell in the column to see if it contains "http" at any stage of its forumla. Is what I'm trying to do possible?

Edit: At request, This is the whole sheet, to give further context.

Upvotes: 1

Views: 114

Answers (1)

player0
player0

Reputation: 1

FORMULATEXT does not support arrays so you can do only:

=COUNTIF({FORMULATEXT(C2); FORMULATEXT(C3)}, "*http*")

Upvotes: 1

Related Questions