ExcelBanter - SUMIF between 2 dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF between 2 dates (https://www.excelbanter.com/excel-worksheet-functions/449699-sumif-between-2-dates.html)

rhhince[_2_]

SUMIF between 2 dates

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

SUMIF between 2 dates

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

All times are GMT +1. The time now is 11:01 AM.