I have created a Dynamic Named Ranges which works as should SUMming numbers but I want to use a COUNTIF function to count names. The Table is named Clients and I want to count how many "Marys" are in my list. the list expands about 100 rows per week so a range of cells is not a practical solution. The current formula is: =COUNTIF(Clients,"Mary")

Thanks for help in advance