title: "CountIF" formula not counting some cells
body: <p>I have an excel document with learners marks in one column and levels in the other. The levels are from 1 to 7 and have been inserted using the "Lookup" function. When I use  "countif" to find the number of learners in each level some cells are not counted. Retyping the levels manually solves the problem but its hectic for large lists.</p>