Sum range of values that meet date criteria
 

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

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


.

or use sumproduct
=sumproduct((sheet1!$a$2:$a$200a2)*(sheet1!$a$2:$ a$200<=b2)*sheet1!$B$2:$b$
200)
or name your ranges and use
=sumproduct((datesa2)*(dates<=b2)*amounts)
--
Don Guillett
SalesAid Software

"Ed Wurster" wrote in 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