Check if sumproduct array contains only unique values

Dear All,

I am facing a problem and can't get my head around it.

Given:

	col A	col B	col C	col D
row 1	10	a	1.2	x
row 2	20	b	1.1	y
row 3	15	a	1.3	z
row 4	30	a	1.4	x
row 5	25	e	1.5	y

So what my initial formula does - sums product of col A and C, provided col B has value "a": =SUMPRODUCT(A1:A5,C1:C5,--(B1:B5="a")). So it sums products of columns for rows 1,3 and 4. (since for rows 2 & 5, 3rd array in SUMPRODUCT returns 0.

Where I would like to get is - as a separate formula: for those rows where third array returned 1, i.e. for rows where column B = "a", I would like to see if all values in column D in respective rows are the same. So, in this case: Look at D1, D3 & D4 and see if they are all the same. [in this case it is not, as when you compare x, z and x -> not all the same]. I don't even need the count of duplicates, simple 1/0 as the result would do.

If you have any suggestions, would very much appreciate those.

Many Thanks,
Michael

Hi Xor Lx,

Many thanks, this does work!

Could you please help out with the case when you have multiple criteria, ie:

B1:B5 has to be "a",

E1:E5 has to be "e"

F1:F5 has to be "i"

Cheers

Perfect, thanks!