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 |
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? |
All times are GMT +1. The time now is 06:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com