One way:

=SUMIF(Sheet1!A:A,"="&A1,Sheet1!B:B)-SUMIF(Sheet1!
A:A,""&B1,Sheet1!B:B)

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a database on Sheet1. Column A contains dates,
the database is sorted
ascending. Column B contains my values.

On Sheet2 I want to sum information from the database in
weekly increments.
On Sheet2 I've entered the start date for the week in
Column A, and the end
date for the week in Column B.

What formula could I use in Column C (Sheet2) to sum a
week's data from
Column B (Sheet1)?

I've searched google groups, and tried a few things, but
struck out.
Ed


.