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