Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating data within a date range
Does anyone have any ideas on how to calculate data that is listed by date
(not necessarily in date order. I am trying to come up with a week ending subtotal in a summary sheet from a number of different worksheets. My data is listed as shown in each worksheet. If anyone could offer a formula to put in my summary sheet it would be greatly appreciated. Column b Column I Date Net weight in tonnes 3/09/2007 37.5 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating a Data Range | Excel Discussion (Misc queries) | |||
Calculating for a specific date range | Excel Worksheet Functions | |||
Sum data by date range | Excel Discussion (Misc queries) | |||
Selecting data within a date range | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions |