Right, I got that part, it is the next column over that is not working properly. The formula you gave me does count the number of entries, but it counts the total number of entries based on name. What I need it to do is count each Category individually. For example. Jordan Hill could have 3 separate reviews. However, one of those reviewers does not have to fill in each category. So even though she has 3 total reviews, she could potentially have only 2 scores in a given category. I updated the workbook and highlighted the column that I am having trouble with in Yellow.
Bookmarks