where a1 and a2 have dates
=sumproduct((a3:a367=a1)*(a3:a367<a2)*b3:b367)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dena" wrote in message
...
I am trying to add how much production was done at our facility per week. I
have 2 worksheets one for a weekly total and one for daily production. I
want
to enter the data in the daily spreadsheet and then have a formula add the
production numbers based on the dates that fall in that work week.
October 1st is the first so I do not need a greater than and less than
formula for that one only a greater than 10-5-08 formula. For week 1 in
October I tried =sumif('Daily Production'!A3:367,"<A3",'Daily
Production'!B3:B376) but it comes back zero. I also need to know how to
get
the numbers for week 10-5-08 thru 10-11-08 11 and so on for the rest of
the
year.

This is what my spreadsheets look like:

Week
Worked" # Sorted
10/1/2008
10/5/2008
10/12/2008
10/19/2008
10/26/2008

Day # Sorted
10/1/2008 100
10/2/2008 100
10/3/2008 100
10/4/2008 100
10/5/2008 100
10/6/2008 100
10/7/2008 100
10/8/2008 100
10/9/2008 100