Countif Contains Help

[Ben1985]

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

[Pete_UK]

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

[kbkumar]

Perhaps something like below, assuming the Word "TESTWORD" is in cell D1:

Please Login or Register  to view this content.

[AndyLitch]

=COUNTIF(D1:D400,A1)

That will count all the instances of cell A1 in the range D1:D400

[Ben1985]

Thanks guys worked a treat.

Ben