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

SadieW

Hello!

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!

DKazatsky2

Hi @SadieW,

You can use the following.

=COUNTIFS(Note:Note, "", Name:Name, "Katie")

Substitute the name for each count needed.

Hope this helps,

Dave

DKazatsky2

Hi @SadieW,

You can use the following.

=COUNTIFS(Note:Note, "", Name:Name, "Katie")

Substitute the name for each count needed.

Hope this helps,

Dave

SadieW

Thank you for the help!