bpeltzer,

That worked beautifully. The answer is so simple yet it eluded me. I would
never have thought of incorporating the height and width options of OFFSET as
I don't think I have ever had cause to use them before. Thank you so much
for taking your time to help me. I greatly appreciate it.

bpeltzer wrote:
You could create your arrays using the longer form of the offset function.
If your start and end dates are in B2 and B3, the first array would be
something like offset($g$1,($b$2+6-date(2007,12,31)),0,$b$3-$b$2+1,1). I'd
be inclined to define names for the first row and number of rows that you
want to include, so that you'd wind up with an array definition like
offset($G$1,first_row-1,0,row_count,1)

I am stumped on this one. I need to calculate the sumproduct on two columns
from data in a different workbook but the range will vary according to start
[quoted text clipped - 8 lines]

Ray