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