How to determine the values?

[Eric]

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]
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

 

[Jacob Skaria]

If you mean the number of instances where 28 and 1 are in the same row; then
try the below

=SUMPRODUCT((28=T2:T1252)*(1=U2:U1252))

 

[Ms-Exl-Learner]

=SUMPRODUCT((T1:T20=28)*(U1:U20=1))

Remember to Click Yes, if this post helps!

 

[T. Valko]

Try this...

=SUMPRODUCT(--(T2:T1252=28),--(U2:U1252=1))

 

[Eric]

Thank everyone very much for suggestions
Could you please tell me what the difference is having -- before "("?
Thank everyone very much for suggestions
Eric

Try this...

=SUMPRODUCT(--(T2:T1252=28),--(U2:U1252=1))

--
Biff
Microsoft Excel MVP

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]
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

.

 

[David Biddulph]

Double unary minus:
a.. http://www.mcgimpsey.com/excel/formulae/doubleneg.html
b.. http://xldynamic.com/source/xld.SUMPRODUCT.html

--
David Biddulph

Thank everyone very much for suggestions
Could you please tell me what the difference is having -- before "("?
Thank everyone very much for suggestions
Eric

Try this...

=SUMPRODUCT(--(T2:T1252=28),--(U2:U1252=1))

--
Biff
Microsoft Excel MVP

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]
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

.