Sum range of values that meet date criteria

[Ed Wurster]

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

 

[Jason Morin]

One way:

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

HTH
Jason
Atlanta, GA

 

[Don Guillett]

or use sumproduct
=sumproduct((sheet1!$a$2:$a$200>a2)*(sheet1!$a$2:$a$200<=b2)*sheet1!$B$2:$b$
200)
or name your ranges and use
=sumproduct((dates>a2)*(dates<=b2)*amounts)