Im trying to create a spreadsheet that helps monitor student participation in my classroom. Id like the spreadsheet to count the instances of a name referenced from another column. This will save me having to tediously enter the names of the students into the column B formula by hand, which is what Ive been doing. In other words, I want to do something like this:
Column A : contains student names. Bob Smith for example.
Column B : something like: =COUNTIF(O5:O11,"*(A5)*")
In other words, it references the name in the first column, and looks in the area O5:O11 (or whatever) to find the instances of the name Bob Smith.
However, the problem is that it keeps returning a value of 0 for this. It works when you reference a number in column A, but not a set of alphanumeric data. Any ideas how to fix this?
Bookmarks