ExcelBanter - multiple column match per row

I didn't see your original question, but the attached should help,
either to match to F1 G1 and H1 (rows 1 to 3) or to the corresponding
column F G and H entry for the row.

adragton Wrote:
Please see attachment- forum display messed up

Multiple columns(A,B,C) which must be match against column
Criteria(F,G,H).
Column(D) displays EXACT MATCH "YES".
TOTAL count of "YES" displayed.
example-
----Criteria-----
A B C D F G H
11 aa 123 YES 11 aa 123
22 aa 123 NO
11 aa 123 YES

TOTAL MATCH ##

+-------------------------------------------------------------------+
|Filename: Image.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=61|
+-------------------------------------------------------------------+

--
adragton

+-------------------------------------------------------------------+
|Filename: Iff.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4560 |
+-------------------------------------------------------------------+

--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528820