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" <(E-Mail Removed)> wrote in message
news:41C27169-129F-466E-84F4-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:41C27169-129F-466E-84F4-(E-Mail Removed)...
> >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
>
>
>