Hey,
So I know a countif statement for counting cells that contain a specific string of text is =COUNTIF(Breakdown!D285,"TESTWORD*") for example. But how do I make it link to a cell?
So I have a list of 400 items that I want to use the contains if statement but I can't link it to the cell, only enter the text manually.
Any help appreciated.
Thanks,
Ben
I think you mean this:
=COUNTIF(Breakdown!D285,"*"&A1&"*")
assuming the test word is in cell A1 of the current sheet.
Hope this helps.
Pete
Perhaps something like below, assuming the Word "TESTWORD" is in cell D1:
Formula:
=COUNTIF(Breakdown!D285,D1&"*")
If solved kindly remember to mark Thread as solved.
Click the small star icon at the bottom left of my post if this was useful.
=COUNTIF(D1:D400,A1)
That will count all the instances of cell A1 in the range D1:D400
Elegant Simplicity............. Not Always
Thanks guys worked a treat.
Ben
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Ben1985 
Register To Reply
Bookmarks