Comparing Dates using Greater Than and Less than

W

waipio2

I am using this formula =IF(12/31/2004<A1:A11<2/1/2005, SUMIF(C1:C11,
"CASH",D1:D11),0)
to add values from this chart based on their label and the date range under
which they fall
1/14/2005 CASH $20.00
1/31/2005 CASH $40.00
2/15/2005 CASH $60.00
2/28/2005 CASH $434.00
3/15/2005 CASH $23.00
3/31/2005 CASH $34.00
4/15/2005 CHECK $100.00
4/29/2005 CHECK $112.00
5/13/2005 CHECK $116.00
5/31/2005 CHECK $8,779.00
12/31/2005 CHECK $787.00

The sytax seems ok, but it always says zero. I think my problem is trying to
get the date range right. Can someone tell me what I am doing wrong?
Thanks
 
R

Ron Rosenfeld

I am using this formula =IF(12/31/2004<A1:A11<2/1/2005, SUMIF(C1:C11,
"CASH",D1:D11),0)
to add values from this chart based on their label and the date range under
which they fall
1/14/2005 CASH $20.00
1/31/2005 CASH $40.00
2/15/2005 CASH $60.00
2/28/2005 CASH $434.00
3/15/2005 CASH $23.00
3/31/2005 CASH $34.00
4/15/2005 CHECK $100.00
4/29/2005 CHECK $112.00
5/13/2005 CHECK $116.00
5/31/2005 CHECK $8,779.00
12/31/2005 CHECK $787.00

The sytax seems ok, but it always says zero. I think my problem is trying to
get the date range right. Can someone tell me what I am doing wrong?
Thanks
Click to expand...


Simpler:

=SUMPRODUCT((Date>=DATE(2005,1,1))*(Date<=DATE(2005,1,31))*(Type="CASH")*Amt)


--ron
 
Top