Does anyone have any suggestions on how to determine the values?
There are lists of number under column T and U.
For example, I would like to determine the number of occurrence, if any 28
under T column contains 1 under U column, then return the occurrence under
column Y, On following formula, it does not work, does anyone have any
suggestions on what wrong it is?
=SUMPRODUCT((28=T2:T1252)*(1=U2:U1252),1)
Thanks in advance for any suggestions
Eric

[T] [u]
28 1
32 2
33 2
34 1
35 1
28 3
32 3
33 5
34 4
35 5
28 1
32 5
33 4
34 3
35 2
28 1
32 5
33 4
34 3
35 2