how to find how any elements are in a column in exel code example Example: Excel sheet count rows =COUNTIF(RANGE, CONDITION) Example: =COUNTIF(C1:C30, "Paris")