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??

08-15-2014, 01:23 AM

LuckyPunch LuckyPunch is offline

Windows 7 32bit Matching Criteria against a range when criteria is not in contiguous cells??

Office 2013

Novice

Join Date: Aug 2014

Posts: 3

Hi GMorris,

Try this
=SUM(IF(FREQUENCY(MATCH(D2:K2,D2:K2,0),MATCH(D2:K2 ,D2:K2,0))>1,1))

Enjoy

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 11:51 AM.