I would suggest a cell reference that you can either change the date in the
one place manual each week, or use the formula "=today()" and the it would
change in the cell automatically.

AB

"prhrmk" wrote:


I am using the SUMPRODUCT formula which is working great - however, when
I copy and past it I have to manually change the dates which is going to
take me a lot of time to do so. I want a formula that will do this for
me when I copy it. If that makes sense? I have bolded the parts that
need to change.

=SUMPRODUCT(--('[MyRecord Log
2006.xls]Rockford-06'!$L$2:$L$65536),--('[MyRecord Log
2006.xls]Rockford-06'!$N$2:$N$65536=--"*2006-01-01*"),--('[MyRecord
Log 2006.xls]Rockford-06'!$N$2:$N$65536<=--"*2006-01-06*"))

Is there a formula - like OFFSET that would do this for me otherwise I
have to change the dates manually. The report is done on a weekly
basis so the dates would be the following:

=SUMPRODUCT(--('[MyRecord Log
2006.xls]Rockford-06'!$L$2:$L$65536),--('[MyRecord Log
2006.xls]Rockford-06'!$N$2:$N$65536=--"*2006-01-09*"),--('[MyRecord
Log 2006.xls]Rockford-06'!$N$2:$N$65536<=--"*2006-01-13*"))

so on and so forth.

Thanks for the help in advance!


--
prhrmk
------------------------------------------------------------------------
prhrmk's Profile: http://www.excelforum.com/member.php...o&userid=23934
View this thread: http://www.excelforum.com/showthread...hreadid=495193