Adding numbers based on date
=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
|