Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding numbers based on date
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding certain numbers based on... | Excel Discussion (Misc queries) | |||
Adding numbers based on partial text in adjacent cells | Excel Discussion (Misc queries) | |||
Adding numbers in cells based on colour | Excel Worksheet Functions | |||
adding specific cells based on a corresponding date | Excel Worksheet Functions | |||
Adding a column based on greater than a date | Excel Worksheet Functions |