SUMIF Complicated.

[Guest]

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.

 

[Guest]

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

 

[daddylonglegs]

Your formula is nearly there...

try it without the quotes around 2 (if 2 is a number) and a +0 afte
the date like this

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

 

[vezerid]

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

HTH
Kostis Vezerides