How do I?
Try
=SUMPRODUCT(--(C17:K17=D101:L101))
If this post helps click Yes
---------------
Jacob Skaria
"Bert" wrote:
Cells d101 thru l101 have values say 4 4 5 6 7 2 3 3 7 and cells c17 thru k17
have values say 4 5 7 6 6 3 3 4 6. How
do I return a value of 3 since there are 3 matches between the two ranges?
What formula can I use without getting too involved?
|