![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lookup using 2 criteria | Itsbarbara | Excel | 16 | 10-07-2013 02:53 PM |
Counting cells with multiple complex criteria | TishyMouse | Excel | 12 | 12-06-2012 05:05 AM |
Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |
![]() |
apolloman | Excel | 6 | 08-24-2011 05:38 AM |
How to count cells containing data and meet certain criteria | AdamNT | Excel | 1 | 08-11-2006 11:51 PM |