Matching Criteria against a range when criteria is not in contiguous cells??

		Microsoft Office Forums > Microsoft Excel > Excel
Matching Criteria against a range when criteria is not in contiguous cells??

FAQ

Thread Tools

Display Modes

08-14-2014, 09:24 PM

GMorris

Windows XP Matching Criteria against a range when criteria is not in contiguous cells??

Office 2010 64bit

Novice

Join Date: Aug 2014

Posts: 3

Example worksheet attached

I just want to count how many individuals were on duty on any given day. I thought I might be able to do this by comparing the employee names (Criteria captured in columns "F" "G" "I" & "K") with the list of all employee names on the second tab??

Attached Files

Example Workbook.xlsx (11.6 KB, 13 views)

« Previous Thread | Next Thread »

Similar Threads
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
Selecting blank cells in criteria	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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:47 AM.