First one

=SUMPRODUCT(--(Tabulation!$A$3:$A$54=$C$1-WEEKDAY($C$1)+1),--(Tabulation!$B$3:$B$54<=
$E$1),--(Tabulation!AV$3:AV$54))


Don't understand what you mean by the second.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"j razz" wrote in message
ps.com...
=SUMPRODUCT(--(Tabulation!$A$3:$A$54=$C$1),--(Tabulation!$B$3:$B$54<=
$E$1),--(Tabulation!AV$3:AV$54))

Givens:
$A$3:$A$54 = a range of dates starting with each sunday of each week.
$B$3:$B$54 = a range of dates ending on each saturday of each week.
AV$3:AV$54 = a range of data that I am wanting the formula to look at
and post the results from.

I am having a problem with this formula. If the date manually entered
in cell $C$1 is say 3/19/2007 and the date manually entered in cell $E
$1 is say 3/24/2007 my problem is as follows: If I have an entry that
begins on 3/19/2007 it is not counted unless I change the date to the
day before. Another issue is that the ending date is not capping off
the returned data from the range AV$3:AV$54. It is as if the <=$E$1
does not exist.

Any ideas on how to fix these issues?

Thanks,

j razz