Thank you EdMac, that does help.

Now, this may be stretching it a little, but is it possible to automatically populate the COUNTIF lists with new names as they are added to the source table? Or would I need to instead add each new name as I add them to the first list?

Thanks again--I appreciate it.