SUMIF Complicated.
 

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.

SUMIF Complicated.
 

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.

SUMIF Complicated.
 

Your formula is nearly there...

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

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=505089

SUMIF Complicated.
 

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

HTH
Kostis Vezerides