Adding numbers based on date

I have a workbook that on the first workbook page has a column with a date
(when a bid is submitted), then in another column the amount of that bid - on
another workbook page I have the weeks of the year and I want it to reference
back to the first workbook page and if the date is between a certain date
range add the bid amount

First Workbook Page Second Workbook Page
Bid Date Amount Week Ending
Amount
1/1/08 $100.00 1/7/08

1/12/08 $200.00 1/14/08
1/25/08 $100.00

Anyone have any suggestions, I have been trying to use the IF function and
SUMIF but I keep getting errors.

Thank you!!
Dyanna

=SUMIF(Sheet1!A:A,"="&A2,Sheet1!B:B)-SUMIF(Sheet1!A:A,""&A2+7,Sheet1!B:B)

--
HTH

Bob

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

"Dyanna" wrote in message
...
I have a workbook that on the first workbook page has a column with a date
(when a bid is submitted), then in another column the amount of that bid -
on
another workbook page I have the weeks of the year and I want it to
reference
back to the first workbook page and if the date is between a certain date
range add the bid amount

First Workbook Page Second Workbook Page
Bid Date Amount Week Ending
Amount
1/1/08 $100.00 1/7/08

1/12/08 $200.00 1/14/08
1/25/08 $100.00

Anyone have any suggestions, I have been trying to use the IF function and
SUMIF but I keep getting errors.

Thank you!!
Dyanna

Thank you - worked perfect - I was close, but I was not using -SUMIF in the
middle!

Dyanna

"Bob Phillips" wrote:

=SUMIF(Sheet1!A:A,"="&A2,Sheet1!B:B)-SUMIF(Sheet1!A:A,""&A2+7,Sheet1!B:B)

--
HTH

Bob

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

"Dyanna" wrote in message
...
I have a workbook that on the first workbook page has a column with a date
(when a bid is submitted), then in another column the amount of that bid -
on
another workbook page I have the weeks of the year and I want it to
reference
back to the first workbook page and if the date is between a certain date
range add the bid amount

First Workbook Page Second Workbook Page
Bid Date Amount Week Ending
Amount
1/1/08 $100.00 1/7/08

1/12/08 $200.00 1/14/08
1/25/08 $100.00

Anyone have any suggestions, I have been trying to use the IF function and
SUMIF but I keep getting errors.

Thank you!!
Dyanna