SUMIF between 2 dates

[rhhince]

Summing it falls between to dates. This is not working. Need a fix. Thanx!


=SUMIF(b17:b50000,">"&DATE(1/1/2003),b17:b50000,"<"&DATE(12/31/2003),n17:x50000)

Ray

 

[Claus Busch]

Hi Ray;

Am Mon, 13 Jan 2014 21:29:36 -0800 (PST) schrieb rhhince:

Summing it falls between to dates. This is not working. Need a fix. Thanx!

=SUMIF(b17:b50000,">"&DATE(1/1/2003),b17:b50000,"<"&DATE(12/31/2003),n17:x50000)

try:
=SUMPRODUCT((YEAR(B17:B50000)=2003)*N17:X50000)
or
=SUMPRODUCT((B17:B50000>=DATE(2003,1,1))*(B17:B50000<=DATE(2003,12,31))*N17:X50000)


Regards
Claus B.