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

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:B500 00<=DATE(2003,12,31))*N17:X50000)


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2