#1
|
|||
|
|||
Rolling 30 Day Total
Currently I use the attached workbook to manage my flight hours. I need to implement a form of fatigue management so I need to start having a rolling 30 day total on my daily flight hours. If you look on the March Tab, I have a SUMIF formula in Column R, Row 38 that totals the hours from Column F for the previous 30 days.
For other days I will need to reference the previous sheet. My question is: How do I do that? Any assistance would be greatly appreciated. Thank you! |
#2
|
|||
|
|||
A solution based on reference to a previous sheet seems cumbersome to me. I attach a file where I have shown another possibility in which, by the way, it will be very easy to make a pivot table.
|
#3
|
|||
|
|||
If a VBA macro solution interests you...
Here's one that will calculate the 30 day total when the flight hours is entered in column F. Assumptions are that the 12 monthly sheets are the only sheets in the workbook, the sheets are in order, and the cell in column A immediately after the last day of the month is blank. Some of yours were blank and some had spaces in them. |
#4
|
|||
|
|||
Aloha Xor & No Sparks!
Thank you, both, for your rapid response! I was up against a deadline so I ended up using a helper sheet which isn't the most effective or logical way but it got the job done. Now that the system was approved I can incorporate a more effective way of getting the same result in order to optimize results in the future. I will definitely look deeper into both angles - Pivot Tables and Macros. Thank you again and have wonderful days! HelicopterChick |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rolling up monthly results based on weeknum? | chollyred | Excel | 1 | 08-26-2016 08:20 AM |
30 Day Running or Rolling total (Multiple Sheets/Workbooks) | HelicopterChick | Excel | 3 | 08-23-2016 04:52 AM |
30 Shift Rolling Average | tandchas | Excel | 7 | 07-02-2014 12:56 AM |
Coordinate rolling text in a webinar | ar8294 | PowerPoint | 1 | 11-28-2012 12:55 AM |
Data From One Slide Rolling Up To Another | Kdubb4410 | PowerPoint | 0 | 07-28-2010 11:28 AM |