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, 10:54 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

Thanks so much but I just tried the formula and it gives me an incorrect total e.g. row 2 says 4 when it should be 3 (Employee3 + Employee5 + Employee8) and row 3 says 5 when it should be 3 (Employee3 + Employee5 + Employee8 + nobody on shift) etc. Any ideas?

« 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 02:37 AM.