Excel: count occurrences of a cell's text Jun 20, 2012 • Noel Count occurrences of cell S2 in all of column S =COUNTIF(S:S, S2)