| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a date range
Hi is their any way if I have a sheet with multiple data and dates, that the totals can all be summed by date eg if i have column A with a start date, column b with an end date and column c with a total in one sheet. can I have another sheet that will sum the data by date. the end date needs to pickup the previous date that is listed. Thanks for your help. -- david72 ------------------------------------------------------------------------ david72's Profile: http://www.excelforum.com/member.php...fo&userid=7980 View this thread: http://www.excelforum.com/showthread...hreadid=543253 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summing a date range
david72 wrote:
Hi is their any way if I have a sheet with multiple data and dates, that the totals can all be summed by date eg if i have column A with a start date, column b with an end date and column c with a total in one sheet. can I have another sheet that will sum the data by date. the end date needs to pickup the previous date that is listed. Thanks for your help. How's about a pivot table? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced filter a dynamic date range | Excel Worksheet Functions | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| help how to crate group of date with Dynamic Range? | Excel Discussion (Misc queries) | |||
| Need help with date range | Excel Discussion (Misc queries) | |||
| adding occurrences for date range | Excel Discussion (Misc queries) | |||
Linear Mode
