Hi,

I have a list like below:
DATES VALUES
01.01.2004 100
05.05.2004 200
01.10.2004 300
01.03.2005 400
01.04.2005 QQQ(text)
10.07.2005 600
08.03.2006 (Blank)
01.04.2006 800
15.05.2006 900
(Blank)(Blank)
............... ........

I want to calculate between

Start date 01.01.2005
End date 31.12.2005

by the =SUMPRODUCT((A2:A20=D22)*(A2:A20<=D23)*(B2:B20)) formula, but
this formula gives #VALUE! result.

How I can solve this problem.

Thanks.


--
sgm020
------------------------------------------------------------------------
sgm020's Profile: http://www.excelforum.com/member.php...o&userid=26226
View this thread: http://www.excelforum.com/showthread...hreadid=567786