Hi everyone -- first off, the answers I get are SO INCREDIBLY helpful. THANK
YOU!

Okay -- here's what I'm trying to do. I have a spreadsheet that looks like:

A1 (campaign start date): 3/15/07
A2 (campaign end date): 5/4/07

Row 6 -- 1/1/07 1/2/07 1/3/07 1/4/07 ... 12/31/07
Row 7 -- 1 5 2 4 7

I would like to add row 7 with the campaign date range. Here is the formula
I'm trying, but it is not working:

=SUMPRODUCT(--(AND(DATEVALUE(A6:Z6)=A1,DATEVALUE(A6:Z6)<=A2)),--(A6:Z6<""),A7:Z7)

Any thoughts out there? This isn't working -- I get #VALUE!.

Thanks much.

Ellen