ok i tried sumproduct but i dont think its reading my dates.. I keep getting 0

=SUMPRODUCT(--(A2:A64000="2"),--(B2:B64000="1/24/2006"),U2:U64000)

help

"cbanks" wrote:

I have numbers 1-10 in Column A.. I am only interested in the number 2..
Column b has dates.. 1/24/2006 is the day i also want..
if column a is 2, and b is 01/24/06, then i need it to sum whats it is in
row U for that cell.

here is what i have.. i basically need 2 criterias.. and im stumped.

=SUMIF($A$2:$A$64000,2,$U$2:$U$64000)

help please.