LinkBack URL
About LinkBacks
Is there a formula that can count the times a certain word is in the column?
Is there a formula that can count the times a certain word is in the column?
=COUNTIF(A1:A10,"word")
or
=COUNTIF(A1:A10,"*word*")
if you want wildcards.
I should of been more clear.
I need it put the word in cell with the number
Like 9 No's, 11 Yes
Note: SUBSTITUTE is case sensitive, hence the UPPER function.
Please Login or Register to view this content.
Why not to use:
="there is = " & COUNTIF(A2:A13,"yes") & " yes"
assuming data are in column A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks