You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:a5baf921c4105@uwe...
yep- thank you again

T. Valko wrote:
If I undersatand what you want...

=SUMPRODUCT(--(ISNA(MATCH(G2:G6,J2:K2,0))),--(H2:H6=L2))

one last Q before you retire to bed ;-)
how to countif value of 6 (L2), for those not in range J2:K2 ?
[quoted text clipped - 27 lines]
thanks in advance
brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201003/1