If that's the case, then everything seems to check out. The formula
that Biff offered should return the desired result.

In article <7ee8a1c97cd54@uwe, "sam518 via OfficeKB.com" <u4102@uwe
wrote:

Hi Domenic,

Domenic wrote:
Let's assume that the numbers for a row in "Refs" are...

201 202 207 208 210

...and that the corresponding numbers in "Data" are...

7 7 36 35 7

If the criteria is as follows...

=201
<=207
=7

...does it meet the criteria and, therefore, be counted as one?
Yes.

This qualifies as Refs 201-207 x2 Data duplicate
201,202,207,208,210
7,7,36,35,7

This qualifies as Refs 201-207 x2 Data duplicate
201,202,207,208,210
7,35,7,7,7

This does NOT qualify as Refs 201-207 x2 Data duplicate
201,202,207,208,210
7,7,7,35,7

Cheers,
Sam