I would like a simple function that can help keep a dynamic count of males
and females assigned to a section. For example we will say there is a list
of 100 employees. 50 males, 50 females. I could put them on a list on sheet
two, possibly in two columns. On sheet one I could list the exact employee
names for employees assigned to different areas. Below each area I would
have a count of names to list how many males and how many females were
assigned to the area based upon the two lists placed on sheet 2.

If possible I would like to accomplish this with no VBA or helper columns
because others would be using the schedule and making assignments every day.
Is this practical? I know how to work with Excel functions but can not come
up with a combination that would accomplish this. Exact matching of names
will work because we always copy and paste names when moving and assigning
employees in the schedule.
Quin