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

On Tue, 7 Jun 2005 12:14:02 -0700, "waipio2"
wrote:

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


Simpler:

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


--ron