Count number of NonBlank cells for each name that appears on a sheet


I have a large list of repeating names (for our purposes let's say Susan, Jake, and Katie) that are assigned multiple Projects. For each of these projects, there may or may not be a note. I am trying to figure out how to count the number of times there is a nonblank cell for each person based on this dataset. Thanks in advance!

Best Answer