Counting based on location & dates
 

Thanks MIKE for your response,

Though they are not adjacent columns, the following is the sequence,

Employee name (Column B)
Location (Column E)
Date of employment (Column G)

Hope this info will be help you

Thanks



"Mike" wrote:

You don't say how your columns are ordered so I have assumed the date entered
service is column C and locations are column D. I have assumed a location of
Leeds but this could equally be a cell address.

=SUMPRODUCT(--(D2:D10="Leeds"),--(C2:C10G7),--(C2:C10<G8))

The 2 dates you specify are in cells G7 and G8

Mike

"jpreman" wrote:

Thanks for reading this post.

Have an Excel sheet which includes among others the following column headings;

Employee No
Employee Name
Date of employment
Location
Salary amount

How could I count the number of employees who had joined the service between
two specific dates (eg. 01 Jan 2005 and 01 Jan 2006), for each location.