Hi,

Am Sun, 24 Mar 2013 11:58:35 +0000 schrieb ser_man:

Thank you for your reply; it's been very helpful.
Is there any way that the date won't be defined in the formula, but
instead it will be defined by another cell value (for example date(a5)),
since the reference to the date is what caused the problem from the
begining?

start date in A5, end date in A6:
=SUMPRODUCT(--(Sheet1!$A$1:$A$1000=A5),--(Sheet1!$A$1:$A$1000<=A6),Sheet1!$B$1:$B$1000)


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