This is my first post on this forum, not too familiar with it, if there's an answer for my question on a thread that I might have missed, please post.

Question:

I have set up a calendar on my spreadsheets with names and other info under each day. I would like to count the number of employees that worked for that one month. How do I get excel to count if any of the names (from a list) appear on that certain month?

I have tried doing the countif+countif+countif... formula but I have a long list of employees (20 names)

Thanks.