Using "if" & "and" functions

So I have a mix of spreadsheet data, some with words and some with formulas. Can someone help me with the instruction entry  I would make when I want to find all cells in a certain column, say column...