View Single Post
 
Old 08-14-2014, 05:06 PM
GMorris GMorris is offline Windows XP Office 2010 64bit
Novice
 
Join Date: Aug 2014
Posts: 3
GMorris is on a distinguished road
Default Matching Criteria against a range when criteria is not in contiguous cells??

Can someone help me please?

I want to match criteria (individual employee names) with a range (list of all employees) to count how many 'individuals' were on shift on any given day. The criteria is not in contiguous cells and I think this is my problem?? The names of employees on shift (the criteria) are in Colums E2, G2, I2 and K2.

Lets say the range is a list of 10 employees on the second Tab called "Employees", I have tried something like this: -

=COUNTIF (Employees!A1:A10, "E2,G2,I2,K2") but it does not work - obviously because I know little in Excel

NB. An employee can do a 'double shift' e.g. their name can appear twice in one day if they work AM and PM, but I only want to match and count their name once as I just want to know how many people were on duty any given day.

There are a maximum of 31 rows as the data is recorded daily for each month but I can drag the formula (once I have it) to populate all rows.

Thank you
Reply With Quote